Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
My system was recenly upgraded to the 2007 version. When I mail merge a
spreadsheet into a letter I loose the currency format, numbers revert to a general format. How can I keep the currency format from the excel file when it mergers to a word document. |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Hi BobBon,
To control number & currency formatting in Word, add a numeric picture switch to the mergefield. To do this: .. select the field; .. press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData}; .. edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see below); .. position the cursor anywhere in this field and press F9 to update it; .. run your mailmerge. Note: The '\# $,0.00' in the field is referred to as a numeric picture switch. Other possibilities include: .. \# 0 for rounded whole numbers .. \# ,0 for rounded whole numbers with a thousands separator .. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator .. \# $,0 for rounded whole dollars with a thousands separator .. \# "$,0.00;($,0.00);'-'" for currency, with brackets around negative numbers and a hyphen for 0 values The precision of the displayed value is controlled by the '0.00'. You can use anything from '0' to '0.000000000000000'. If you use a final ';' in the formatting switch with nothing following, (eg \# "$,0.00;($,0.00);") zero values will be suppressed. Note that this suppresses 0s resulting from empty fields and from fields containing 0s. -- Cheers macropod [Microsoft MVP - Word] "BonBon" wrote in message ... My system was recenly upgraded to the 2007 version. When I mail merge a spreadsheet into a letter I loose the currency format, numbers revert to a general format. How can I keep the currency format from the excel file when it mergers to a word document. |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I format Mail Merge doc to pick up currency format from Exc | Mailmerge | |||
Office 2003 Mail merge not preserving currency format | Mailmerge | |||
Access currency field wont format correctly in word mail merge | Mailmerge | |||
Currency fields in Access lose th currency format whn merged why | Mailmerge | |||
How do I format numbers as Currency via Mail Merge? | Mailmerge |