Excel problem

Aug 5, 2001
190
0
71
I have the strangest thing happening with my Excel - when I enter a number in a cell, it is automatically divided by 10. For example, if I type in 100, it becomes 10. I have explicitly set the cell format to numbers, created new files, reinstalled excel... but to no avail. Note this effects only new entries in exisitng files (and all enteries in new file). Ran Norton thinking this might be virus, but nothing... help please!
 

PowerEngineer

Diamond Member
Oct 22, 2001
3,600
775
136
Here's a possibility (from Excel Help):

Enter numbers with a fixed decimal point
On the Tools menu, click Options, and then click the Edit tab.
Select the Fixed decimal check box.
In the Places box, enter a positive number for digits to the right of the decimal point or a negative number for digits to the left of the decimal point.

For example, if you enter 3 in the Places box and then type 2834 in a cell, the value will be 2.834. If you enter -3 in the Places box and then type 283, the value will be 283000.

On the worksheet, click a cell, and then enter the number that you want.
Note Data that you entered before selecting the Fixed decimal option is not affected.

Tip To temporarily override the Fixed decimal option, type a decimal point when you enter the number.

I'm betting someone has set yours to -1 ! :D