3 Ways To Convert Text To Numbers In Excel
Sometimes you get data and something doesn’t look right. See below. The data in the left column is formatted as text. Therefore, it is useless in calculations (you can see that, when I summed the column, the result was zero).
What you will often want instead is for these “numbers” to be truly formatted as numbers — so that you can use them in formulas.
Below, I have converted the text in the left column to actual numbers in the right column. You can see that the SUM function now works.