Suppressing Decmal zero's

N

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
 
D

Dave Peterson

Isn't that what General will do?

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

neil40

Isn't that what General will do?

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

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
 
D

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
 
D

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.
 
C

challa prabhu

Hi,

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

Challa Prabhu
 
N

neil40

Hi,

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

Challa Prabhu








- Show quoted text -
Click to expand...

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
 
Top