#1
|
|||
|
|||
How to format WORD data using edit field?
My source data in EXCEL show 0.1. But when I merge into WORD, it show 9.15....E-2b. How can I make it show 0.1 and exactly to 1 decimal place? |
#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. 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. Note2: If you use a decimal tab or right-aligned tab to align the values and insert a tab into the field code after the $ sign, you can have the values output like: $ 999,999.99 $ __9,999.99 (where the _ represents the additional right-tab spacing)
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thank you very much! It works!
Last edited by macropod; 04-01-2013 at 06:10 PM. Reason: Delete unnecessary quote of entire post replied to |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Merge field source data field | kckay | Mail Merge | 4 | 03-25-2013 11:06 AM |
Can't Edit Data in Word Chart | Dan Reed | Word | 1 | 01-26-2012 04:25 PM |
Edit Data Source- Linking template charts to new data | lbf | PowerPoint | 0 | 10-28-2011 12:19 PM |
Edit Multiple Emails' User-Defined Field | ryancaseymcshane | Outlook | 0 | 10-04-2011 07:40 AM |
Can't select or edit chart data | itguy | PowerPoint | 2 | 09-19-2010 10:13 AM |