Prev: how do i create a formula to give a workday date?
Next: what does the size 1/72 means
From: Cass1930 on 19 Mar 2010 09:55
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!
From: Teethless mama on 19 Mar 2010 10:11
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!
From: Brad E. on 19 Mar 2010 10:18
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.


"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!
 | 
Pages: 1
Prev: how do i create a formula to give a workday date?
Next: what does the size 1/72 means