Introduction to converting text to numbers

In this module of the Data Cleanup Course you will learn about all the issues that confuse Excel into seeing a number (based on what the human sees) as some form of text and therefore not treating it as a number (does not add it, gives VALUE errors with calculations). This can be as a result of multiple issues varying from regional settings (comma as a decimal or full stop?), to strange characters, apostrophes in front of the number and more…

Back to: