0 of 45 lessons complete (0%)
Convert ‘Text’ fields into usable numbers

Introduction to converting text to numbers

This is a preview lesson
Purchase this course, or sign in if you’re already enrolled, to take this lesson.

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.

As shown below, the impact of this is that your totals are WRONG!


You will learn how to use either tools (for quick fixes) or formula (for template creation) to clean up this data and make it usable.