Excel stores formatting separate to data and mailmerge in Word only accesses
the data. To reinstate the formatting in a merge document, you must add
formatting switches to the merge fields.
To see how to do that, take a look at the item "Formatting Word fields with
switches" on fellow MVP Graham Mayor's website at:
http://www.gmayor.com/formatting_word_fields.htm
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Susan Bompadre" Susan
wrote in message
...
Please help: Word taking the commas out of fields that contain numbers
when
using mail merge into form letters. Data file is in Excel, and the
spreadsheet is formatted correctly.