How do you merge a dollar amount into a word doc and keep the $?

[Campo]

I am trying to merge from Excel to Word. When I merge a cell with a currency
amount that was formatted from the format cell to currence, it doesn't keep
the currency formatting. It drops the $ and the decimal. Is there a way to
merge and keep the formatting?

 

[ryguy7272]

This is a great resource:
http://www.gmayor.com/formatting_word_fields.htm


Regards,
Ryan--
--
RyGuy

You can either use the field formatting options within Word, or in Excel use
=TEXT(A1,"$#,##0.00") [modifying the format to suit your requirements]
--
David Biddulph

I am trying to merge from Excel to Word. When I merge a cell with a
currency
amount that was formatted from the format cell to currence, it doesn't
keep
the currency formatting. It drops the $ and the decimal. Is there a way
to
merge and keep the formatting?