Simple Number Formatting Question

[Former Member]

Need a formula for some number formatting.

If a number is a whole number I need it to show no decimal places, just the number itself.

So: 7.000 would be 7

if a number is not a whole number i need it to show three decimal places

So: 7.25 would be 7.250

Thanks for the help!

[vitaly_izmaylov · Accepted solution]

If you need it for display only, then you can convert it to text using the following formula:

numbervar x:={your number};

if x=round(x) then totext(x,0) else totext(x,3)