Merge data from xcel to word
 

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.

Merge data from xcel to word
 

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.

Merge data from xcel to word
 

You could use a helper cell with a formula like =TEXT(A2,"$0.00")
or otherwise there are field formatting facilities in Word, for which
hopefully the Word experts can give advice.
--
David Biddulph

"jpcontrol" wrote in message
...
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.

Merge data from xcel to word
 

You may want to try something like this:
http://www.gmayor.com/formatting_word_fields.htm

Regards,
Ryan---

--
RyGuy


"David Biddulph" wrote:

You could use a helper cell with a formula like =TEXT(A2,"$0.00")
or otherwise there are field formatting facilities in Word, for which
hopefully the Word experts can give advice.
--
David Biddulph

"jpcontrol" wrote in message
...
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.