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".
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