Does the { MERGEFIELD percent2 } alone result in a number being displayed?
Did you use Ctrl+F9 for both pairs of field delimiters { }
Make sure that you have a space either side of the * operator and between
the # and the 0
{ = { Mergefield percent2 } * 100 \# 0% }
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"cottage6" <cottage6[ at ]discussions.microsoft.com> wrote in message
news:2E6A675B-3EE5-469D-A66C-2B9F5FC7612E[ at ]microsoft.com...
[Quoted Text] > Hello everyone,
> I'm trying to help a user with a mail merge I believe was originally done
> in
> Word 2000; current user has 2002 with Excel 2002. It seems I have 2
> different problems:
> 1) There are 4 "percent" fields, percent1 - percent4. Looks to me like
> percent1 has been used for all 4, so I need to change the last 3 fields.
> In
> Step 4 of the merge I've been clicking on "More items" and selecting the
> percent2, percent3, and percent4 fields that way.
> 2) The percent fields are formatted as percent with 0 decimals in Excel.
> When the merge occurs the actual value of the cell is what shows in Word.
> I
> tried to edit the field using Ctrl + F9 with this code { ={ Mergefield
> percent2 }*100 \#0%}. I am getting an !Undefined Bookmark error when I do
> the merge.
>
> Any ideas? I don't know what to do. TIA
|