Excel currency format does not translate correctly in a Word merge
"ILoveMyCorgi" wrote in message
...
When I merge an Excel file with various fields/formats, the currency
formats
[seven different columns with currency] the Word file displays 70 instead
of
$70.00. What do I need to do and in which file?
Excel formatting only affects how the cell appears in Excel. If the actual
cell contents is 70, that's how it will appear in Word. Not sure if you can
reformat it in Word but you certainly can add '$' in text before the 70 and
'.00' after it.
V
|