#1
|
|||
|
|||
Switches
How do I get a merge using a Word file and an Excel file come out with one number and two decimal places after and not 9 places after? I need step by step instructions, if possible.
|
#2
|
||||
|
||||
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, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thank you!!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Index switches | cksm4 | Word VBA | 2 | 02-03-2011 07:21 AM |
Mail merge switches | Jan Collier | Mail Merge | 0 | 08-29-2010 06:06 AM |
Command Line Switches | Ringmaster | Office | 0 | 08-10-2010 06:27 AM |
Help with switches: Word mail merge with Excel | ks_ | Mail Merge | 0 | 12-09-2009 05:09 PM |