Getting currency formatting to fill in final 0

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cindy B - 21 Feb 2006 18:25 GMT

Quick question... I'm doing a mail merge from Excel for currency amounts.
When the data merges, I can get it formated to currency and to 2 decimal
places. The one piece that is outstanding, is when there is only 1 number
after the decimal point, instead of adding a 0, it does not show 2
characters.
so... if the amount is $340.20
what it's bringing up is: $340.2
I'm thinking there must be a formating parameter that I'm missing???
Appreciate any ideas you might have - thanks in advance for your help!

Signature

Cindy B

Reply to this Message

Peter Jamieson - 21 Feb 2006 18:36 GMT

Are you using a "format switch" in Word, e.g.

{ MERGEFIELD myfield \#$,#.## }

?

If so, you probably need to change any "#" characters to the right of the
decimal point to "0" characters, e.g.

{ MERGEFIELD myfield \#$,#.00 }

If not, can you provide more detail about how you are formatting the
numbers?

Peter Jamieson

> Quick question... I'm doing a mail merge from Excel for currency amounts.
> When the data merges, I can get it formated to currency and to 2 decimal
[quoted text clipped - 5 lines]
> I'm thinking there must be a formating parameter that I'm missing???
> Appreciate any ideas you might have - thanks in advance for your help!

Reply to this Message

Cindy B - 21 Feb 2006 19:25 GMT

That's what it was - thanks for your help!!!
You are awesome!

Signature

Cindy B

> Are you using a "format switch" in Word, e.g.
>
[quoted text clipped - 21 lines]
> > I'm thinking there must be a formating parameter that I'm missing???
> > Appreciate any ideas you might have - thanks in advance for your help!

Reply to this Message