How do I maintain number formatting in a mail merge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Skittles - 27 Jan 2005 17:33 GMT

When creating a mail merge that will import data from an EXCEL spreadsheet,
the number formatting changes. Trailing zeros, commas, and decimal points
vanish. How can I maintain the formatting on the spreadsheet?

Reply to this Message

Doug Robbins - 28 Jan 2005 03:22 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> When creating a mail merge that will import data from an EXCEL
> spreadsheet,
> the number formatting changes. Trailing zeros, commas, and decimal points
> vanish. How can I maintain the formatting on the spreadsheet?

Reply to this Message