Merging from Excel to Work

[Jane]

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

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

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

--
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