Format calculation results

[Guest]

Hi,
I have a text box with the data calculated as a percentage of
sales/mailings. I'd like it to be limited to 2 decimal places. Input mask
isn't working as ##.##\%;;_ presumably because the data is being calculated
rather than being "input."

How can I limit this expression to 2 decimal places?
=[txtSales]/[txtNumber mailed]*100

Thank you,
Karl

 

[Guest]

Hi.

Try eliminating the *100 from your formula, then formatting the TextBox
as Percent, and setting Decimal Places to 2.

-Michael

 

[Guest]

Hi Michael,
Thanks so much for your help. It worked perfectly!
Yours,
Karl

Hi.

Try eliminating the *100 from your formula, then formatting the TextBox
as Percent, and setting Decimal Places to 2.

-Michael

Hi,
I have a text box with the data calculated as a percentage of
sales/mailings. I'd like it to be limited to 2 decimal places. Input mask
isn't working as ##.##\%;;_ presumably because the data is being calculated
rather than being "input."

How can I limit this expression to 2 decimal places?
=[txtSales]/[txtNumber mailed]*100

Thank you,
Karl