Two digit number with one decimal, or three digit number

C

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!
 
B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top