On 22 Apr, 00:25, Dave Peterson wrote:
Isn't that what General will do?

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

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

--

Dave Peterson

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