How to Convert Text to Numbers in Excel 2016

Join us on Facebook
Our App

In this tutorial, we’re going to show you how to convert text to numbers in Excel 2016.
Rarely will you ever run into this problem, and even then, Excel 2016 does a good job of working past it. The error is usually denoted by a green flag in the top left of the cell. Simply click the cell or cells, hit the error button, and choose Convert to Number.

This is a HowTech tutorial, visit our website and watch our videos for more.

[katejackson]

Thanks, I'm trying to convert huge volumes of text from a download and the text to columns worked a treat!

[Orholam]

your thumbnail is misleading...you're not showing how to convert word numbers like twenty to 20

[Harnas]

I have copied numbers form website and past them to excel. Now, none of these methods work to convert text number to number.