Sounds like somebody played a prank on you


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Mona" wrote in message
...
Thanks Very much Niek. It was Autocorrect option to change 0 to -1

"Niek Otten" wrote:

Autocorrect maybe?
Check ToolsAutocorrect Options

--
Kind regards,

Niek Otten

"Mona" wrote in message
...
| Whenever I type in just 0 in Excel 2000, it gets converted into -1
| automatically and for all the formulas, excel treats it as -1 and not
0.
| Please help!!!!