Why does the number format change in a mail merge doc?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

marymarsh - 20 Jun 2005 03:13 GMT

Since upgrading to Word 2003 my mail merge documents (database in excel 2003)
return a result without number separators (commas) even though they show in
the spreadsheet and appeared in merge results before the upgrade. Can anyone
help?

Reply to this Message

Anne Troy - 20 Jun 2005 03:37 GMT

See:
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm

You'll want something like the one we show for "invoice", though perhaps
without the dollar sign.

The data connection method changed in newer versions. It sucks now.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

> Since upgrading to Word 2003 my mail merge documents (database in excel 2003)
> return a result without number separators (commas) even though they show in
> the spreadsheet and appeared in merge results before the upgrade. Can anyone
> help?

Reply to this Message

Doug Robbins - 20 Jun 2005 19:01 GMT

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

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

Signature

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

> Since upgrading to Word 2003 my mail merge documents (database in excel
> 2003)
[quoted text clipped - 3 lines]
> anyone
> help?

Reply to this Message