Getting currency formatting to fill in final 0

[Cindy B]

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!

 

[Peter Jamieson]

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

 

[Cindy B]

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