How do I format a number in a currency format in word

[Guest]

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]

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
--

 

[Dave Peterson]

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.)