I am doing a mail merge using number fields from an excel pread sheet. How
can I format them like currency i.e. $1,287.22. Can the execl format be
passed to word?
Can this be done or must I use the field edit and use the \# switch ?
David McRitchie - 14 Sep 2004 05:29 GMT
Convert it to a Text field is one one way.
F1: =TEXT(E1,"_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)")
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
If you are more familiar with MS Word than with Excel
Control Word from Excel
[-- http://www.erlandsendata.no/english/index.php?d=envbaolecontrolword --]
Send information to Word (e.g. creating a new document) and retrieve information from Word (e.g. reading information from a
document). -- Erlandsen Data Consulting. See comments in code, you will need to set a reference in the VBE (Visual Basic Editor)
for example in Excel 2000 -- Tools, References, [x] Microsoft Word 9.0 Object Library
Control Excel from Word
[-- http://www.erlandsendata.no/english/index.php?d=envbaolecontrolexcel --]
Send information to Excel from Word (e.g. creating a new workbook) and retrieve information from Excel (e.g. reading information
from a workbook). -- Erlandsen Data Consulting

Signature
---
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
> I am doing a mail merge using number fields from an excel pread sheet. How
> can I format them like currency i.e. $1,287.22. Can the execl format be
> passed to word?
>
> Can this be done or must I use the field edit and use the \# switch ?
Dave Peterson - 15 Sep 2004 01:11 GMT
Debra Dalgleish posted this for a different question:
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 two decimal places.
For example:
{ MERGEFIELD FieldName \# "#,##0.00" }
4. Press Alt+F9 to hide the field codes.
5. Save the Main Document
(I bet you could modify it for your situation.)
> I am doing a mail merge using number fields from an excel pread sheet. How
> can I format them like currency i.e. $1,287.22. Can the execl format be
> passed to word?
>
> Can this be done or must I use the field edit and use the \# switch ?

Signature
Dave Peterson
ec35720@msn.com