+ Reply to Thread
Results 1 to 3 of 3

Mail Merge - Formatting Prices from Excel Spreadsheet

  1. #1
    Registered User
    Join Date
    05-20-2013
    Location
    Apple Valley, MN
    MS-Off Ver
    Excel 2007
    Posts
    11

    Mail Merge - Formatting Prices from Excel Spreadsheet

    I'm working on a mail merge for a letter to clients that is supposed to include the amount they have withdrawn so far this calendar year. When first pulling the information from the spreadsheet, the format will post as "1234.56" and I have to change the format using Toggle Field Codes to \# $,#.00 in order for the information to post as "$1,234.56".

    The problem I have right now is for those who have not withdrawn anything and so they are supposed to pull in as "$0.00", however they are currently pulling in as "$.00". What do I need to change in order to get "$0.00" without risking the loss of the format for "$1,234.56"?

    Thank you,
    Madelyn
    Last edited by MadelynL; 11-29-2016 at 01:01 PM. Reason: Solved

  2. #2
    Registered User
    Join Date
    05-20-2013
    Location
    Apple Valley, MN
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Mail Merge - Formatting Prices from Excel Spreadsheet

    I figured it out, for anyone who is interested, it is : \# $,#0.00

  3. #3
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Mail Merge - Formatting Prices from Excel Spreadsheet

    Even simpler: \# $,0.00

    For more useful info, see the Mailmerge Tips and Tricks thread at:
    http://www.msofficeforums.com/mail-m...ps-tricks.html
    or:
    http://windowssecrets.com/forums/sho...ips-amp-Tricks
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA Program integrating Publisher Mail Merge and Excel Spreadsheet
    By SBBmaster09 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2015, 04:12 AM
  2. Mail Merge - Excel Work Timesheet spreadsheet
    By Vibro in forum Excel General
    Replies: 0
    Last Post: 03-16-2015, 06:44 PM
  3. Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  4. Replies: 15
    Last Post: 04-17-2013, 02:20 AM
  5. Excel spreadsheet/database/mail merge and pop ups to notify of flagged content
    By KarenNZ1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2013, 07:04 PM
  6. Replies: 2
    Last Post: 04-14-2013, 10:45 PM
  7. mail merge an Excel 2010 spreadsheet
    By StrawberryFields in forum Excel General
    Replies: 0
    Last Post: 09-24-2012, 11:51 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1