thousand separator number - not coming thru to Word mail merge

  • Thread starter Thread starter bzc
  • Start date Start date
B

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?
 
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
 
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")
 
Back
Top