C
Conrad
I formatted an EXCEL worhseet to include the comma separator for numbers greater than 1,000. I cannot get the comma to transfer to a MS WORD form letter after performing a mail merge.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Debra Dalgleish
In the Mail Merge, after you select your Excel file as a data source,
you should see a 'Confirm Data Source' dialog box.
(If you don't see the dialog box, change the setting in Word --
under Tools>Options, General -- add a check mark to
'Confirm Conversion at Open')
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 a comma separator.
For example:
{ MERGEFIELD FieldName \# "#,##0" }
4. Press Alt+F9 to hide the field codes.
5. Save the Main Document
you should see a 'Confirm Data Source' dialog box.
(If you don't see the dialog box, change the setting in Word --
under Tools>Options, General -- add a check mark to
'Confirm Conversion at Open')
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 a comma separator.
For example:
{ MERGEFIELD FieldName \# "#,##0" }
4. Press Alt+F9 to hide the field codes.
5. Save the Main Document
D
Domenic
Hi Conrad,
You should be able to rectify this by adding a numeric switch (\#
"#,###") to your merge field code in your Word document.
Try,
Alt+F9 to reveal the merge field code in your Word document
Change it to read:
{ MERGEFIELD Fieldname \# "#,###" }
If you want 2 decimal places, then you can change it to:
{ MERGEFIELD Fieldname \# "#,###.00" }
Hope this helps!
You should be able to rectify this by adding a numeric switch (\#
"#,###") to your merge field code in your Word document.
Try,
Alt+F9 to reveal the merge field code in your Word document
Change it to read:
{ MERGEFIELD Fieldname \# "#,###" }
If you want 2 decimal places, then you can change it to:
{ MERGEFIELD Fieldname \# "#,###.00" }
Hope this helps!
D
David McRitchie
Hi Conrad,
In the Confirm Data Source dialog box,
click the MS Excel Worksheets via DDE (*.xls), and then click OK.
another way would be to make a copy of your worksheet and
convert all cellst to text. If it is just one column you
could create a column to use =TEXT(G2,"#,###.00")
and copy down by double click on file handle, or Ctrl+D
Mail Merge
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
In the Confirm Data Source dialog box,
click the MS Excel Worksheets via DDE (*.xls), and then click OK.
another way would be to make a copy of your worksheet and
convert all cellst to text. If it is just one column you
could create a column to use =TEXT(G2,"#,###.00")
and copy down by double click on file handle, or Ctrl+D
Mail Merge
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
a MS WORD form letter after performing a mail merge.Conrad said:I formatted an EXCEL worhseet to include the comma separator for numbers greater than 1,000. I cannot get the comma to transfer to