ExcelBanter - when i type in 0 in excel 2000 it converts into -1

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - when i type in 0 in excel 2000 it converts into -1 (https://www.excelbanter.com/excel-discussion-misc-queries/87943-when-i-type-0-excel-2000-converts-into-1-a.html)

Mona

when i type in 0 in excel 2000 it converts into -1

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!!!!

All times are GMT +1. The time now is 07:08 AM.