Suppressing Decmal zero's

[neil40]

Hi

Is it possible that I can format cells so that numbers that have zero
after the decimal point show without the .0 but other numbers with
values after the decimal point show?

Example, I have formatted a set of cells to have a single decimal
place but I want 248.0 to show as 248 but I also want 248.5 to show as
248.5

Thanks
Neil

 

[Dave Peterson]

Isn't that what General will do?

The bad news is that =1/3 may not show what you want.

 

[Guest]

=IF(MOD(A1,1)=0,INT(A1),A1)

 

[neil40]

Isn't that what General will do?

The bad news is that =1/3 may not show what you want.

Dave
General will remove the .0 but it also rounds others, so 523.5 becomes
524
The other solution works though, (Teethless mama's)
Neil

 

[Dave Peterson]

Try widening the column so you can see more digits--or change to a smaller font.

Either way will let you see 523.5 as 523.5

 

[David Biddulph]

What version of Excel do you have where General causes 523.5 to round to 524
(unless the cell width is too narrow to display 523.5)?

What cell format do you have that allows Teethless mama's solution to work?
I would expect it to work only if the cell format is General, in which case
it doesn't need the formula.

 

[Guest]

Hi,

On the Format Toolbar, click the Increase decimal or decrease decimal button.

Challa Prabhu

 

[neil40]

Hi,

On the Format Toolbar, click the Increase decimal or decrease decimal button.

Challa Prabhu








- Show quoted text -

That would work but not acceptable as the column of numbers could be
either .5 or .0 as it's a League table derived from a ranking.
The 'General' format and column widening resolved it, though I would
have expected a series of #### if the number was too wide, Have seen
that before.
Thanks all
Neil