Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Number format wrong when using a formula in merge field
I know this is simple but can't seem to find the solution:
The formula is to mulitply a mergefield by 13.33% The result comes out .000 even using \# $#,###.## {={mergefield \# $#,###.##}*.13.33} |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Number format wrong when using a formula in merge field
Something more like
{ ={ MERGEFIELD mynumber }*0.1333 \# "$,0.00" } is more likely to do it. Each pair of {} needs to be the field braces you can insert using ctrl-F9, not the regular keyboard characters "{" and "}" Peter Jamieson "taz" wrote in message ... I know this is simple but can't seem to find the solution: The formula is to mulitply a mergefield by 13.33% The result comes out .000 even using \# $#,###.## {={mergefield \# $#,###.##}*.13.33} |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I format zip code merge field to add hyphen if zip plus 4? | Mailmerge | |||
Insert Field - Database - Wrong Date Format | Mailmerge | |||
Suppressing Merge Field and text before/after | Microsoft Word Help | |||
Wrong mail merge date format | Mailmerge | |||
How merge a field with RTF format | Mailmerge |