MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
12Next
Return Post new threads
View: 733|Reply: 14

Mail Merge - Formatting Prices from Excel Spreadsheet [SOLV

[Copy link]

1

Topics

6

Posts

15

Integral

Member

Rank: 2

Integral
15
Post on 11-30-2016 09:33:27 | All posts |Read mode
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












Reply

Props Report

1

Topics

6

Posts

15

Integral

Member

Rank: 2

Integral
15
 Author| Post on 11-30-2016 11:09:17 | All posts



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




Reply Support Opposition

Props Report

2

Topics

188

Posts

466

Integral

Conqueror

Rank: 3Rank: 3

Integral
466
Post on 11-30-2016 12:37:09 | All posts



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
Reply Support Opposition

Props Report

1

Topics

6

Posts

15

Integral

Member

Rank: 2

Integral
15
 Author| Post on 11-30-2016 12:23:49 | All posts



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




Reply Support Opposition

Props Report

2

Topics

188

Posts

466

Integral

Conqueror

Rank: 3Rank: 3

Integral
466
Post on 11-30-2016 12:58:54 | All posts



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
Reply Support Opposition

Props Report

1

Topics

6

Posts

15

Integral

Member

Rank: 2

Integral
15
 Author| Post on 11-30-2016 13:44:42 | All posts



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




Reply Support Opposition

Props Report

2

Topics

188

Posts

466

Integral

Conqueror

Rank: 3Rank: 3

Integral
466
Post on 11-30-2016 14:42:46 | All posts



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
Reply Support Opposition

Props Report

1

Topics

6

Posts

15

Integral

Member

Rank: 2

Integral
15
 Author| Post on 11-30-2016 16:32:15 | All posts



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




Reply Support Opposition

Props Report

2

Topics

188

Posts

466

Integral

Conqueror

Rank: 3Rank: 3

Integral
466
Post on 11-30-2016 16:49:20 | All posts



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
Reply Support Opposition

Props Report

1

Topics

6

Posts

15

Integral

Member

Rank: 2

Integral
15
 Author| Post on 11-30-2016 17:37:59 | All posts



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




Reply Support Opposition

Props Report

12Next
Return Post new threads

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 11-20-2017 00:35 , Processed in 0.248068 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!