How to stop automatic division of numbers in Excel
 

Hi,
For some reason whenever I enter numbers into Excel 2003 now without the =
sign beforehand, the number shows up as if I divided it by 10,000 (i.e. 1
becomes .0001). I don't know what I did to start this problem but I can't
figure out how to solve it.
Thanks for any help,
Justin

Hi!

Goto ToolsOptionsEdit

And see if you have Fixed Decimal Places set to 4.

Biff

-----Original Message-----
Hi,
For some reason whenever I enter numbers into Excel 2003
now without the =
sign beforehand, the number shows up as if I divided it
by 10,000 (i.e. 1
becomes .0001). I don't know what I did to start this
problem but I can't
figure out how to solve it.
Thanks for any help,
Justin
.

Justin

ToolsOptionsEdit. Uncheck "fixed decimal places"


Gord Dibben Excel MVP

On Sat, 19 Feb 2005 22:37:03 -0800, Justin
wrote:

Hi,
For some reason whenever I enter numbers into Excel 2003 now without the =
sign beforehand, the number shows up as if I divided it by 10,000 (i.e. 1
becomes .0001). I don't know what I did to start this problem but I can't
figure out how to solve it.
Thanks for any help,
Justin