Excel: numbers in cells get divided by 100: all spreadsheets ...

[Alfred A. Aburto Jr.]

Hi,
I have a strange problem that I don't know how to fix. I'm using Excel
2000. Something happened recently and I'm not sure why or how, but in
every spreadsheet I have if one enters a number into a cell the number
will be divided by 100 automatically. This happens in all my
spreadsheets, so I thought Excel might have been corrupted somehow. I
have reloaded Excel, actually "Office 2000", three times now and, also,
I tried to delete any files that I thought might be related to Excel
(before reloading again) but the problem remains. I've looked and tested
all the menu items but I have not come upon a feature that causes the
problem (or solves it). Could it be that every Excel file I have has
been modified somehow so they all have this problem that I don't know
how to get rid of? I'm almost at my wits end with this. I'm using MS
Windows Me.

Any ideas to help would be greatly appreciated!
Al

 

[Bob Phillips]

Go to Tools>Options>Edit. You should see that the Fixed decimal box will be
checked, uncheck it.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Alfred A. Aburto Jr.]

Go to Tools>Options>Edit. You should see that the Fixed decimal box will be
checked, uncheck it.

Wow! Thank you so much!
Al