[Suzamo]

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!