Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
BonBon BonBon is offline
external usenet poster
 
Posts: 2
Default mail merge currency format

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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default mail merge currency format

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I format Mail Merge doc to pick up currency format from Exc MamaSherry Mailmerge 2 December 19th 08 04:46 PM
Office 2003 Mail merge not preserving currency format Umtalipete Mailmerge 2 April 27th 07 12:24 PM
Access currency field wont format correctly in word mail merge Marnee Mailmerge 3 June 2nd 05 05:40 AM
Currency fields in Access lose th currency format whn merged why PMasters Mailmerge 1 June 1st 05 08:13 PM
How do I format numbers as Currency via Mail Merge? SteveL67 Mailmerge 1 March 3rd 05 05:32 PM


All times are GMT +1. The time now is 09:38 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"