June 14, 200619 yr 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
Create an account or sign in to comment