Sample file: 4 quick and easy ways to convert numbers stored as text to real numbers in Excel
This is the demonstration file to accompany the article, 4 quick and easy ways to convert numbers stored as text to real numbers in Excel, by Susan Harkins.
From the intro of this Microsoft Excel article:
Numbers stored as text in Microsoft Excel aren’t necessarily wrong. For instance, a street address that begins with numbers—555 Town Street—is stored as text. On the other hand, we often receive data from a foreign source that should be stored as a number, but it stored as text at the source. When this happens, we must convert that text into numbers before we can use the data.
In this Microsoft Excel tutorial, I’ll show you four easy ways to convert numbers stored as text to real numbers. All four methods have their own pros and cons, so knowing them all will come in handy.