SOLVED

0 in front of a number

%3CLINGO-SUB%20id%3D%22lingo-sub-2306297%22%20slang%3D%22en-US%22%3E0%20in%20front%20of%20a%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2306297%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BI%20would%20like%20to%20type%20a%20cell%20number%20from%20South%20Africa%20which%20is%20083%20598%200899.%26nbsp%3B%20But%20you%20know%20it%20takes%20out%20the%200.%26nbsp%3B%20This%20can%20be%20fixed%20on%20a%20excel%20sheet%20by%20typing%20'%20before%20the%200.%26nbsp%3B%20But%20the%20cells%20still%20gives%20a%20that%20little%20error%20log%20which%20I%20can%20not%20have%20on%20as%20I%20am%20doing%20formulas%20in%20the%20same%20sheet.%26nbsp%3B%20I%20need%20to%20know%20how%20to%20take%20the%20little%20error%20block%20of%20a%20number%20that%20start%20with%20a%200%20but%20still%20keeps%20the%200.%26nbsp%3B%20Changing%20it%20to%20TEXT%20does%20not%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2306297%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2306347%22%20slang%3D%22en-US%22%3ERe%3A%200%20in%20front%20of%20a%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2306347%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1034844%22%20target%3D%22_blank%22%3E%40Sandra_Ludick%3C%2FA%3E%26nbsp%3BIf%20it's%20the%20green%20triangles%20you%20mean%2C%20these%20are%20mere%20warnings%20that%20something%20may%20be%20wrong.%20Excel%20tries%20to%20help%20you%20identifying%20numbers%20that%20might%20have%20been%20entered%20incorrectly.%20You%20can%20ignore%20it%20or%20switch-off%20the%20background%20error%20checking.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

 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 a that little error log which I can not have on as I am doing formulas in the same sheet.  I need to know how to take the little error block of a number that start with a 0 but still keeps the 0.  Changing it to TEXT does not work.

 

Kind regards

 

4 Replies

@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
best response confirmed by Sandra_Ludick (Occasional Contributor)
Solution

@Sandra_Ludick Assuming you're in Windows. File, Otions, Formulas, Error Checking. Uncheck the "Enable background error checking".

Screenshot 2021-04-29 at 14.06.14.png

 

Kind regards, worked 100% thank you sooo much