Currency from Excel isn't merging into a Word document properly

[Sharon]

I have data in an Excel spreadsheet that has dollar amounts formatted as
currency to 2 decimal places, but when I try to merge the Excel data into a
Word document the dollar amounts loses all currency formatting. What should
be $1,590.00 but ends up merging as 1590, why?

 

[Graham Mayor]

Word simply inserts the underlying data - add a formatting switch to restore
your currency

{Mergefield Fieldname \# "$,0.00"}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
see http://www.gmayor.com/formatting_word_fields.htm