Two digit number with one decimal, or three digit number

[Cass1930]

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!

 

[Teethless mama]

Custom Format:

[<100]0.0;0

 

[Brad E.]

From the Format Cells window, on the Number tab, select Custom. In the Type
box enter
[<100]0.0;0
This says for anything less than 100 display at least one character for the
whole number and exactly one decimal character; otherwise, display the whole
number.

-- Brad E.