Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
VBA Format Number
I have a word document that is mail merged with access. I have a number that
is formatted in Access to be a percent However when I merge it with the word document I get .23 instead of 23%. I know I have to set the format to read as percent but cant figure out how to do that in word. I have VB €“ Basic opened for the document an have this code: Format([DailyAveOIl1], "Percent") But it does not work [DailyAveOil1] is the merged field. Any help would be great. Thanks Andy |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
VBA Format Number
Hi Andy,
In Word: .. 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%} .. press F9 to update the field .. 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 [MVP - Microsoft Word] "AJOLSON" wrote in message ... I have a word document that is mail merged with access. I have a number that is formatted in Access to be a percent However when I merge it with the word document I get .23 instead of 23%. I know I have to set the format to read as percent but cant figure out how to do that in word. I have VB €“ Basic opened for the document an have this code: Format([DailyAveOIl1], "Percent") But it does not work [DailyAveOil1] is the merged field. Any help would be great. Thanks Andy |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
number format | Tables | |||
Number format and 0's | Mailmerge | |||
Number format field | Page Layout | |||
number format | Microsoft Word Help | |||
How do I make an automatic number small caps under Number Format? | Microsoft Word Help |