Using formula to set decimal place

[1tufgt]

What's the proper method to set the decimal of a field to be a specific length? Example is that I would want all to be 0 decimal place but a couple rows I would like it to expand to .00 decimal places.

 

[kray4660]

I would use the TOTEXT function. You can set the number of decimal places with it. Of course you would need a condition statement to determine when a value needs zero or multiple decimal places.

 

[lbass]

Try the round() function in a conditional formula.

-LB