Introduction to converting text to numbers

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!

introduction-to-convert-text-to-numbers

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.

 

Back to: Data cleanup in Excel > Convert 'Text' fields into usable numbers