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

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?

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

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

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

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

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


Regards,
Ryan--
--
RyGuy


"David Biddulph" wrote:

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

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