Cell formatting

Posted by Roger on November 02, 2001 12:37 AM

Hi everybody
This is a weird one. When I enter a number into a cell which is formatted for a number with two decimal places the cell displays the number divided by a hundred.
It does this to any sheet previously saved and to any new sheet.
Formatting doesn't change things, Norton WinDoctor can't help and I've even re-installed.
Anyone out there got any ideas?

Posted by Robin on November 02, 2001 12:57 AM

Hi! Sounds to me like you have your fixed decimal switched on to 2 places. Go to Tools, Options, Edit and switch it off!

Robin

Posted by Helmut Rahn on November 02, 2001 1:00 AM

Go to Tools>Options>Edit and un-check Fixed Decimal

Posted by Roger on November 02, 2001 3:13 AM

Re: Go to Tools>Options>Edit and un-check Fixed Decimal

Thank you so much you guys. I sweated buckets on that one. I am most grateful (and it was so simple too!)
Roger