| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
VBA Format Number in word
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.docmanagement
|
|||
|
|||
|
VBA Format Number in word
Answered in microsoft.public.word.mailmerge.fields. Please don't make multiple posts of the same topic - use cross-posting instead.
-- 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 | |||
| How can I use Excel accounting number format in Word tables? | Tables | |||
| number format word 2000 | Microsoft Word Help | |||
| How do I make an automatic number small caps under Number Format? | Microsoft Word Help | |||
| Number format in Word forms | New Users | |||
| How do I number documents in Word 2003 with 1.1, 2.1, 2.2 format? | Microsoft Word Help | |||
Linear Mode
