If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Word 2007 mailmerge from excel datasource number format
I have a spreadsheet with cells in it with a format of 1937.69, when I do the
mail it adds a bunch of numbers see below. Is this a word option I need to fix? 1937.6900000000001 -- Thanks for the help |
#2
|
|||
|
|||
Word 2007 mailmerge from excel datasource number format
Hi tinks,
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'. -- Cheers macropod [Microsoft MVP - Word] "tinks" wrote in message ... I have a spreadsheet with cells in it with a format of 1937.69, when I do the mail it adds a bunch of numbers see below. Is this a word option I need to fix? 1937.6900000000001 -- Thanks for the help |
Thread Tools | |
Display Modes | |
|
|