Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting %s in Mail Merges
I am having problems formatting %s in my mail merge. I want it to display as
19.4% but it shows as .194395969999570044 instead. I have tried rounding the number in excel and also adding a numeric picture switch like \# ##.00x but they are not working. Any good insights? Thanks. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting %s in Mail Merges
See the relevant example at http://www.gmayor.com/formatting_word_fields.htm
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org WPK wrote: I am having problems formatting %s in my mail merge. I want it to display as 19.4% but it shows as .194395969999570044 instead. I have tried rounding the number in excel and also adding a numeric picture switch like \# ##.00x but they are not working. Any good insights? Thanks. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merges in Word | Mailmerge | |||
Mail Merges | Mailmerge | |||
Source data formatting in mail merges. | Mailmerge | |||
VBA & Mail merges | Mailmerge | |||
Mail merges | Tables |