headermask image

Business Tools Blog

Convert Numbers to Currency for MS Word Mail Merge

Did you ever try to use numbers in an excel spreadsheet to populate a Word document using mail merge?  If you have then you probably noticed that MS Word loads any number in general format.  Number formatting problems in a mail merge occur when the cells that contain the numbers in the Excel worksheet are formatted as Number, Currency, Date, Percentage, etc.

Example, $1,000.00 in Excel will load as 1000 into a mail merge document.

One way to make the number look like currency in your Mail Merge is to create a new column in excel that converts the number $1,000.00 into Text. Use the following formula: =TEXT(A1,”$#,##0.0″)

Before you use the mail merge, hard code the column with the =TEXT(A1,”$#,##0.00″) formula.  When you import the new column into your mail merge document it will appear as currency.

If you liked my post, feel free to subscribe to my rss feeds

Money Making Options

Post meta

This entry was written by Sandi Mays and posted on September 16, 2009 at 12:44 am and filed under Excel. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment(Latest is displayed first) or leave a trackback: Trackback URL.

Share with others

Post Convert Numbers to Currency for MS Word Mail Merge to digg. Post Convert Numbers to Currency for MS Word Mail Merge to Reddit add to stumbleupon Google Bookmark myweb bookmark on del.cio.us newsvine Tailrank magnolia Furl co.mments shadows simpy blinklist

2 Comments so far (Add 1 more)

  1. Recently, there has been a good deal of inquiries by the
    American FTC against bloggers and website promoters
    for not publishing advertising income, or potential
    connections with advertising agencies.

    What are your personal ideas about how this could potentially impact
    the blogging world?

    1. Doonnaplowl on November 4th, 2009 at 10:36 am

  2. Hello,

    When I’m having issues with mail merging formulae for currency, i’ve been using the following formula:

    =TEXT(A1,”#€,###.00″)

    this helps me with 4 figures (€1,000.00) and also with 3 figures (€100.00) but when i do 2 figures (€10.00) it doesn’t work properly, infact I get it with a space in it like so: € 10.00.

    Obviously this isn’t a massive deal, but wondered if you knew how to make it floor proof for 2 figures and upwards to unlimited figures…

    Ebo

    2. Ebomeister on October 19th, 2009 at 2:57 am

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*