#1
|
|||
|
|||
Mail Merge Number Error
Hi,
I'm trying to mail-merge an Excel document into a Word letter. All the numbers in Excel are in 0.00 (accounting) format (and none of them have 'extra digits' that aren't visible, I triple checked this ), but when it merges into the Word document, it merges like this: 14.300000000000001 (should just be 14.30) or 21.739999999999998 (should just be 21.74). It does this for every number. Any help at all would be greatly appreciated!! |
#2
|
||||
|
||||
Hi Tamarissa,
What you're now seeing is the raw values in Excel. 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] |
#3
|
|||
|
|||
Thank you so much Paul, that worked fantastically !
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge to create specific number of table rows | flackend | Mail Merge | 4 | 12-01-2023 02:49 PM |
Automatically split Mail Merge based on number of pages | SaneMan | Mail Merge | 1 | 12-03-2011 01:11 AM |
Mail Merge, Number to 2 Decimal Places | Vampy99 | Mail Merge | 7 | 09-25-2011 05:41 AM |
Mail merge number fields outputting inconsistently | rekcots | Mail Merge | 2 | 05-18-2011 06:32 AM |
Mail merge error? | SRE | Outlook | 0 | 01-11-2010 05:54 PM |