Ways to convert text to numbers in Excel
A free Office suite fully compatible with Microsoft Office
Using Excel? This tutorial will show you how to convert text to numbers in Excel. There are many reasons why you may wish to convert text to numbers in Excel. For example, if you have a name of a town and want to bin it into Zip code data then you need to convert text to numbers. Or if you want to import some data and they're using codes not text then you need to convert text to numbers. Whatever the reason is, converting real values into their corresponding numbers can help you make better business decisions.
Unfortunately, sometimes you just can't avoid this process due to business requirements and the inability of Microsoft Word or PowerPoint to do what Excel does best. It's not uncommon for a small percentage of data within the data set to be character based and not able to be used for statistical analysis. So it's important that you find a way of converting text to numbers in Excel.
Tips that are provided in this article are compatible with versions 2010/2013/2016.
How to convert text to numbers in Excel: Manual Method
The first way to do it is by manually selecting the text and then converting it to a number.
1.Select the text and click the convert option.
2.Once you click this option,it will be converted to a number and that’s it , that’s how you can convert a number into the text.
How to convert text to numbers in Excel: Cell formatting method
1.The easiest way to convert text to numbers in Excel is by using cell formatting. To do this, you need to select the cells that contain text and then apply a number format from the Home tab of the ribbon.
2.Or just select the cell and left click.
3.Select the format option and then convert it into the number.
4.The text will be converted into numbers.
Now you know how to convert text into numbers in excel.
How to convert text to numbers in Excel: Value function
Value is the most popular and most used function in Excel. It can be used to convert text to numbers by using the VALUE() formula.
1.Value(text) converts a text string into a number. For example, you can use it to convert an alphanumeric string such as 123 into a number 123 by using the VALUE() formula =VALUE(123).
2.For our case, let’s apply it to the previous example and see the results.
3.It has been shown from the above case scenario that converting text to numbers in excel is a very simple task. It is done by using a simple function and with the help of it, we can easily convert all the numbers into numbers or vice versa.
Did you learn how to convert text to numbers in Excel? You can follow WPS academy to learn more features of Word documents, Excel Spreadsheets, and PowerPoint slides.
You can also download WPS Office to edit word documents, Excel Spreadsheets, and PowerPoint free of cost. Download Now! And get an enjoyable working space.
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to add text to beginning or end of all cells in Excel
- 5. How to color cell based on value in Excel?
- 6. How to compare two excel sheets and highlight differences