Weird Problem,,,,,Please Help !!!!
Posted by Dave on January 14, 2002 8:32 PM
I've been working on this spreadsheet, and all of the sudden tonight, every cell that I have set up to enter a percentage in has freaked out.
The cells are formatted for percentage 0.000%
When it was working correctly if I entered 5 it showed 5.000%, 6.25 it showed 6.250% and so on. Now all of the sudden when I try to enter a number in percentage cells it is showing 100 times too much. If I enter 5 it shows 500.000%, if I try 6.25 it shows 625.000%. I have no idea what has happened, but if someone can tell me how to fix it I'd appreciate it.