Forum Discussion
Solved
0 in front of a number
I would like to type a cell number from South Africa which is 083 598 0899. But you know it takes out the 0. This can be fixed on a excel sheet by typing ' before the 0. But the cells still gives...
Sandra_Ludick Assuming you're in Windows. File, Otions, Formulas, Error Checking. Uncheck the "Enable background error checking".
Sandra_Ludick If it's the green triangles you mean, these are mere warnings that something may be wrong. Excel tries to help you identifying numbers that might have been entered incorrectly. You can ignore it or switch-off the background error checking.
- Hi Riny, thanks so much for your reply. Because there is going to tons of numbers I would like to use the second option (which I did not know about) How do I switch of the back ground error checking. Thanks again
Sandra_Ludick Assuming you're in Windows. File, Otions, Formulas, Error Checking. Uncheck the "Enable background error checking".
- Kind regards, worked 100% thank you sooo much
