| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when i type in 0 in excel 2000 it converts into -1
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!!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when i type in 0 in excel 2000 it converts into -1
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!!!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when i type in 0 in excel 2000 it converts into -1
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!!!! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when i type in 0 in excel 2000 it converts into -1
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!!!! | | | | | |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when i type in 0 in excel 2000 it converts into -1
I once switched the monitors on 2 terminals to a mainframe for an old guy (I
was young then) I was working with and it was quite fun to watch him Peo "Niek Otten" wrote in message ... 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!!!! | | | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? | Excel Discussion (Misc queries) | |||
| Hyperlinks from Excel 2000 dont work anymore in Excel 2003 | Excel Discussion (Misc queries) | |||
| Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) | |||
| Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
| how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
Linear Mode
