I was wandering how this could have happened and I didn't even think of your suggestion, which is very likely to be the case!
Maybe my wife *is* right after all and I'm too naive....

--
Kind regards,

Niek Otten

"Peo Sjoblom" wrote in message ...
| 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!!!!
|
|
|
|
|