When trying to enter a negative number, such as -1, excel changes it to 01.
S samr414 Nov 17, 2004 #1 When trying to enter a negative number, such as -1, excel changes it to 01.
B BenjieLop Nov 17, 2004 #2 samr414 said: When trying to enter a negative number, such as -1, excel changes it t 01. Click to expand... I have been trying to duplicate this situation and it just would no happen. Maybe, formatting your cell to GENERAL or NUMBER will help yo solve this
samr414 said: When trying to enter a negative number, such as -1, excel changes it t 01. Click to expand... I have been trying to duplicate this situation and it just would no happen. Maybe, formatting your cell to GENERAL or NUMBER will help yo solve this
J JE McGimpsey Nov 17, 2004 #3 I XL does this while you're editing, check Tools/Autocorrect and delete the entry that converts - to 0. If XL does this only after you hit Enter, check Format/Cells/Number for a custom number format. (e.g., 0;\00;0;@). Or check for an event macro...
I XL does this while you're editing, check Tools/Autocorrect and delete the entry that converts - to 0. If XL does this only after you hit Enter, check Format/Cells/Number for a custom number format. (e.g., 0;\00;0;@). Or check for an event macro...
