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

[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?

[davesexcel]

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?

Fixed decimals

[David Biddulph]

"Becky" <[email protected]> wrote in message
news:[email protected]...
> 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?

Tools/ Options/ Edit
Make sure "Fixed decimal places" is unchecked.
--
David Biddulph

[David Biddulph]

"davesexcel" <[email protected]> wrote
in message news:[email protected]...
>
> 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

[davesexcel]

Oh Yes,
There it is,
Thanks