On 23 Apr, 10:26, challa prabhu
wrote:
Hi,

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

Challa Prabhu



"neil40" wrote:
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- Hide quoted text -

- 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