[macropod]

Hi Suzamo,

You could code around it with:
{IF "{MERGEFIELD Data}" = "{={MERGEFIELD Data}}" "{MERGEFIELD Data \# $,0.00}" "{MERGEFIELD Data}"}
but if you've got a lot of different fields like this, using a DDE connection would be better, as Peter suggests.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Suzamo" wrote in message ...
I have a field in an Excel spreadsheet that can be either currency or text.
I mail-merge it into a Word document. The field contains donation info,
which may be things like "$25.00" or "4 tickets to ABC Theater".

When I add the switch to get the currency to format correctly, it messes up
the format when the field contains text. If I get the $25.00 to format
correctly after the merge, "4 tickets to ABC Theater" looks like "$4.00".
Without the switch, the "4 tickets to ABC Theater" looks good, but the
"25.00" is "25".

Any suggestions? Thanks!