Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2004

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
stevenrb3 - 14 Sep 2004 04:25 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.