The number I type in a cell, e.g. 500, appears at 0.5 - why?

B

Becky

If I type, for exampe, 500 into an excel cell it appear as 0.5 when I press
enter. How do I stop this from happening?
 
D

davesexcel

Becky said:
If I type, for exampe, 500 into an excel cell it appear as 0.5 when I
press
enter. How do I stop this from happening?
Click to expand...
Thats A good one , I couldn't find a format that would do that,
anyway, you should be able to fix it if you format your cell
Right click on the mouse, select format cells
select the numbers tab
Numbers
select the format you want for the cell
 
D

David Biddulph

Becky said:
If I type, for exampe, 500 into an excel cell it appear as 0.5 when I
press
enter. How do I stop this from happening?
Click to expand...

Tools/ Options/ Edit
Make sure "Fixed decimal places" is unchecked.
 
D

David Biddulph

Thats A good one , I couldn't find a format that would do that,
anyway, you should be able to fix it if you format your cell
Right click on the mouse, select format cells
select the numbers tab
Numbers
select the format you want for the cell
Click to expand...

If you want to make it do that, dave, try Tools/ Options/ Edit:
"Fixed decimal places" checked & set to 3.

And, as far as I am aware, setting the numbers format for the cell won't
cure it.

The cure, if that is the problem, is to clear the "Fixed decimal places"
check box.
 
Top