software

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?


Becky Wrote:
gt; If I type, for exampe, 500 into an excel cell it appear as 0.5 when I
gt; press
gt; 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--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=523033quot;Beckyquot; gt; wrote in message
...
gt; If I type, for exampe, 500 into an excel cell it appear as 0.5 when I
gt; press
gt; enter. How do I stop this from happening?

Tools/ Options/ Edit
Make sure quot;Fixed decimal placesquot; is unchecked.
--
David Biddulph
quot;davesexcelquot; gt; wrote
in message ...
gt;
gt; Becky Wrote:
gt;gt; If I type, for exampe, 500 into an excel cell it appear as 0.5 when I
gt;gt; press
gt;gt; enter. How do I stop this from happening?

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

If you want to make it do that, dave, try Tools/ Options/ Edit:
quot;Fixed decimal placesquot; checked amp; 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 quot;Fixed decimal placesquot;
check box.
--
David Biddulph

Oh Yes,
There it is,
Thanks--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=523033