Decimal points in an email

[Inky Phil]

Hello everyone,

I am generating an email to include a numeric field.

I would like the field to appear to 2 decimal places in the email eg 234.56.

The field is a calc field rounded to 2 decimal but if it calcs to 1 decimal place then that is all I get eg 234.5

I know how to add the 0 if I need it. The thing I cannot work out is how to determine IF I need to add the 0. In other words how does one determine that there is only one decimal place in a number?

TIA

Phil

[comment]

See here, for example.

[Inky Phil]

Excellent!

Thanks

Phil