How to format a number.

[lsaapedd]

I have a column of numbers. Most have one decimal number, a few have none e.g.
370
370.0
370.1

Excel will NOT display the .0 in a number and I have not been able to figure
out how to force it. I only want a .0 to show if I actually type it. If a
number has no decimal number entered, I do NOT want one to display. If
anyone can help me with this I will be grateful.

Thanks.

 

[Jacob Skaria]

Pre-format the cells to Text and then enter the numbers..

If this post helps click Yes

 

[lsaapedd]

That works, but, I'd really prefer a numeric format.

lsaapedd

 

[Bernard Liengme]

If you format the alignment to the right, how will you tell if it is text or
number?
You can still treat it as a number with formulas like =A1*2 , =A1<400
best wishes

 

[Dave Peterson]

Excel doesn't work like that. 370 and 370.0 are the same number.

If you don't want to type your values as text, you could format each cell the
way you like (showing as many decimal places as you like).

Or maybe you could build a small userform that asks for your entry. Then it
could look at your entry, plop the value into the cell and format that cell with
as many decimals as it thinks you want.

 

[Jacob Skaria]

Is there any particular reason..