#1
|
|||
|
|||
currency not showing correctly on mail merge
Hi everyone,
can someone please give me what i need to change my current mailmerge code so that my field comes in as £ 1,000.00 and not just 1000 as it does now! thanks Tony |
#2
|
||||
|
||||
Hi Tony,
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. Note1: 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, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Saving INDV mail merges During the mail merge | sedain121 | Mail Merge | 2 | 10-04-2011 07:52 PM |
Date not transfering to mail merge correctly | tonywatsonmail | Mail Merge | 1 | 07-01-2011 05:30 AM |
Formatting Cells for Currency and Accounting | Sparetyme | Excel | 1 | 07-11-2010 01:26 PM |
Unread mail not showing up in Inbox - Outlook 2007 | ayaz_rn@hotmail.com | Outlook | 0 | 04-30-2009 11:32 AM |
change currency $ to £ on excel invoice help | deanorx7 | Excel | 3 | 07-08-2008 04:40 AM |