Thread: Two digit number with one decimal, or three digit number
View Single Post
  #2  
Old March 19th, 2010, 02:11 PM posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
  
Posts: 3,722
Default Two digit number with one decimal, or three digit number
Custom Format:

[100]0.0;0


"Cass1930" wrote:

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!