thousand separator number - not coming thru to Word mail merge

[bzc]

Excel XP was used as database for mail merge. Figures
were money - the format used was thousands separator.
Word mail merge did not receive the separator comma.
Anyone else had this experience? Any fix or work-around?

 

[Dave Peterson]

Debra Dalgleish posted this:

After you select your Excel file as a data source, you should see a
'Confirm Data Source' dialog box. From that list, choose 'MS Excel
Worksheets via DDE (*.xls)', and your formatting will be retained.

If you have to connect through a different source, you can format the
fields in the Word document. For example, to specify a number of decimals:

1. In Word, in the Main Document, press Alt+F9 to view the field codes.
2. Find the field code for the number. It will look something like:
{ MERGEFIELD FieldName }
3. Add a switch, to format the number with two decimal places.
For example:
{ MERGEFIELD FieldName \# "#,##0.00" }
4. Press Alt+F9 to hide the field codes.
5. Save the Main Document

 

[David McRitchie]

Another possibility,
If you want more of an Excel solution with less Word involvement,
you could use another column so that it has TEXT content.
=TEXT(B2,"# "#,##0.00")