Remember that changing the format does not change the number, but
rather the display of the number; Word is still getting the precision
defined in Excel.

One solution would be to truncate (using the trunc() function), but
beware because the precision will be lost in Excel once the document
is saved.

On Jan 16, 3:14 pm, jpcontrol
wrote:
I am having a problem with dollar amounts showing to many decimal places
after the . sign. I have tried to format the cell to only show 2 places, but
in the word document is shows 6 places after the decimal.