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.

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

If this post helps click Yes
---------------
Jacob Skaria


"lsaapedd" wrote:

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.

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

lsaapedd

"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"lsaapedd" wrote:

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.

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"lsaapedd" wrote in message
...
That works, but, I'd really prefer a numeric format.

lsaapedd

"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"lsaapedd" wrote:

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.

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.

lsaapedd wrote:

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.

--

Dave Peterson

Is there any particular reason..
--
If this post helps click Yes
---------------
Jacob Skaria


"lsaapedd" wrote:

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

lsaapedd

"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"lsaapedd" wrote:

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.