Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Getting currency formatting to fill in final 0
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! -- Cindy B |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Getting currency formatting to fill in final 0
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" wrote in message ... 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! -- Cindy B |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Getting currency formatting to fill in final 0
That's what it was - thanks for your help!!!
You are awesome! -- Cindy B "Peter Jamieson" wrote: 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" wrote in message ... 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! -- Cindy B |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Currency formatting | Microsoft Word Help | |||
Final and Final Mark Up | Microsoft Word Help | |||
Word 2003: track changes opens in final view instead of final sho. | Microsoft Word Help | |||
Form Fields lose bold formatting | Microsoft Word Help | |||
Apply Style but keep direct formatting? | New Users |