"davesexcel" wrote
in message ...

Becky Wrote:
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?

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

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