When I merge data from Excel to Word, the currency loses it's formatting i.e. 150.00 come across as 150. Is there any way to preserve the formatting or format a merge field
Hi Jane,
See the article ?Formatting Word fields with switches? on fellow MVP Graham
Mayor?s website at:
http://www.gmayor.com/formatting_word_fields.htm

Signature
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
> When I merge data from Excel to Word, the currency loses it's formatting
> i.e. 150.00 come across as 150. Is there any way to preserve the
> formatting or format a merge field?