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?
|