How can I get a merge field in Word to display only 2 decimal plac

Hi,

I am using word to merge from an excel spreadsheet. In the spreadsheet, I
have numbers entered with two decimal points, almost exclusively either
314.01, 313.81 or 309.81. When I merge that field into a word document, if
the number is 314.01, it displays in the word document as 314.00999999999999.
If the number is either 313.81 or 309.81, the number displays correctly. So
far, I have tried format - cell - number - category "number" with the
"number of decimal places 2," and also format - cell - number - category
"custom" with a bunch of different iterations of ###0.00, to no avail.

Can anyone tell me how to correct this error?

Thanks,

Chris

Excel stores formatting separate to data and mailmerge in Word only accesses
the data. To reinstate the formatting in a merge document, you must add
formatting switches to the merge fields.

To see how to do that, take a look at the item "Formatting Word fields with
switches" on fellow MVP Graham Mayor's website at:

http://www.gmayor.com/formatting_word_fields.htm



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"fatgreta" wrote in message
...
Hi,

I am using word to merge from an excel spreadsheet. In the spreadsheet, I
have numbers entered with two decimal points, almost exclusively either
314.01, 313.81 or 309.81. When I merge that field into a word document, if
the number is 314.01, it displays in the word document as
314.00999999999999.
If the number is either 313.81 or 309.81, the number displays correctly.
So
far, I have tried format - cell - number - category "number" with the
"number of decimal places 2," and also format - cell - number -
category
"custom" with a bunch of different iterations of ###0.00, to no avail.

Can anyone tell me how to correct this error?

Thanks,

Chris