View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cass1930 Cass1930 is offline
external usenet poster
 
Posts: 1
Default Two digit number with one decimal, or three digit number

I would like to have one decimal point in a number, unless the number is 100
in order to fit the columns in a table. So, three digits for whatever number
I type in, and if it is two digits, to have a decimal.

95.6
45.2
80.0
100 - NOT 100.0
123 - NOT 123.0

Thanks!