View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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}