Help! Excel Has Gone Nuts!
 

Right after solving one problem, thanks to help from this board, my excel now
has gone completely berserk.

Any number that is entered in any empty cell is automatically reduced by a
factor of 1000. For example, if you enter the number 1000 and hit enter or
and arrow key, the cell returns the number 1.

This happens without any formulas entered anywhere in a new worksheet, in
every cell.

What is going on?

Regards,

Gordon Arnaut
Ontario, Canada.

Help! Excel Has Gone Nuts!
 

It sounds like you have Fixed Decimal Places engaged....

Try this:

From the Excel main menu:
<tools<options<edit tab
UNcheck: Fixed Decimal Places

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Gordon Arnaut" wrote:

Right after solving one problem, thanks to help from this board, my excel now
has gone completely berserk.

Any number that is entered in any empty cell is automatically reduced by a
factor of 1000. For example, if you enter the number 1000 and hit enter or
and arrow key, the cell returns the number 1.

This happens without any formulas entered anywhere in a new worksheet, in
every cell.

What is going on?

Regards,

Gordon Arnaut
Ontario, Canada.

Help! Excel Has Gone Nuts!
 

Thanks, Ron.

That fixed it.

Regards,

Gordon.



"Ron Coderre" wrote:

It sounds like you have Fixed Decimal Places engaged....

Try this:

From the Excel main menu:
<tools<options<edit tab
UNcheck: Fixed Decimal Places

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Gordon Arnaut" wrote:

Right after solving one problem, thanks to help from this board, my excel now
has gone completely berserk.

Any number that is entered in any empty cell is automatically reduced by a
factor of 1000. For example, if you enter the number 1000 and hit enter or
and arrow key, the cell returns the number 1.

This happens without any formulas entered anywhere in a new worksheet, in
every cell.

What is going on?

Regards,

Gordon Arnaut
Ontario, Canada.