Number format wrong when using a formula in merge field

T

taz

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}
 
P

Peter Jamieson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top