strange Excel behavior


Posted by Tan Le on September 27, 2001 3:41 PM

Hi,

I'd like to report a very strange behavior in Excel 2002. All excel sheets change a whole number to a 100th decimal place. For example, I typed 100 and hit enter then it showed 1.00, I even open new books and still problem persists. I checked the cell format and changed to all kinds of different settings but problem still persists. Every number is automatically divided by 100. I opened a saved workbook with lots of numbers in it. It looks fine until I reenter some numbers and hit enter, they appeared in 100th decimal numbers again. I can't go on like this. Any idea?

Tan Le

Posted by anno on September 27, 2001 4:37 PM

tan le
sounds like the fixed decimal places option has been set. to undo, go to tools|options|edit tab and uncheck the 'fixed decimal places' box.



Posted by Tan Le on September 28, 2001 10:37 PM

Thanks, that works. I should have used that. Now I know. Thanks again!