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" <tinks.RemoveThis@discussions.microsoft.com> wrote in message news:E084C865-1067-43B3-B7BB-3883E23395D4@microsoft.com...
>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