Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge field not displayed correctly
Hi,
I am trying to do a mail merge from an excel sheet which has the data . The field which i have the problem is percentage field instead of displaying 1.30% it shows the following 1.3000000000000001E-2 I tried all the combinations of field formatting but was unable to get it corrected .I have made sure the field in excel is in percentage. Please help Mark |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge field not displayed correctly
Hi Mark,
In Word, add a formula and numeric picture switch to the mergefield. To do this: .. select your mergefield, which will look something like «Percent»; .. press Ctrl-F9 to wrap another field around it, thus - { «Percent» }; .. edit the field so that you get {=«Percent»*100 \# 0.00%}; .. position the cursor anywhere in this field and press F9 to update it; .. run your mailmerge. Note: the precision of the displayed value is controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'. -- Cheers macropod [Microsoft MVP - Word] "Mark" wrote in message ... Hi, I am trying to do a mail merge from an excel sheet which has the data . The field which i have the problem is percentage field instead of displaying 1.30% it shows the following 1.3000000000000001E-2 I tried all the combinations of field formatting but was unable to get it corrected .I have made sure the field in excel is in percentage. Please help Mark |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasted Excel chart not displayed correctly | Microsoft Word Help | |||
The operator sign can't be displayed correctly in Word. Why? | Microsoft Word Help | |||
Access currency field wont format correctly in word mail merge | Mailmerge | |||
IncludeText Field: font of text that is displayed following mail m | Mailmerge | |||
How are several mail merge records displayed on the same page? | Microsoft Word Help |