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

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

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


"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

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

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


neil40 wrote:

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

--

Dave Peterson

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.
--
David Biddulph

"neil40" wrote in message
oups.com...
General will remove the .0 but it also rounds others, so 523.5 becomes
524
The other solution works though, (Teethless mama's)
Neil

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

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

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