How To Convert Text To Numbers In Excel

Are you trying to make your spreadsheet more readable for Excel’s formulas? Here's how

How To Convert Text To Number In Excel

Last Updated on

Early Cyber Monday deals are starting to go live on Amazon & Best Buy. Big brands such as Lenovo and Samsung are also starting to offer Black Friday discounts early, with many more to follow.

While Excel files can accept both text and numbers in the cells, most equations, calculations, and formulas that the program runs need numerical values to function properly and give you a result. As such, it is an important skill to learn to be able to convert text to numbers in Excel to function at its best.

The following methods will give you plenty of options for converting these values.

1

Changing The Cell Formats Of Excel

This is probably the easiest method for converting text data in your cells into numbers.

Step

1

Go To Home Tab

To change the format of your cells, go to the ‘Home’ tab of your excel worksheet, and then go to the numbers section of the page.

In this section, there is a drop-down box that you can click to specify the values in your spreadsheet.

Click on the drop-down box, and select ‘Number’.

Go To Home Tab

Step

2

Right-Click On The Cells

Right-click on the cells, and select the ‘Format cells’ option on the menu that appears.

From here, you can also change the values of the spreadsheets. To change them from text to numbers, select the ‘Number’ option that appears.

Select The Convert To Numbers

2

Use The Warning Symbol In Your Spreadsheet.

This is a very useful option if your spreadsheet naturally finds a text value in the spreadsheet where there would otherwise be a numerical value.

Step

1

Value Must Show A Warning Symbol

To use this method, the value must show a ‘warning’ symbol over the value.

If you do see the symbol, select it to show the drop-down menu of options.

Step

2

Select ‘Convert To Numbers’

Of these options, select the ‘convert to numbers’ option.

This will correctly format the information in the cell, and get rid of the warning symbol as well.

3

Use Text To Columns

Using ‘Text to Columns’ is a feature that is normally used when trying to split a selected amount of data into separate columns. However, it can also be used to turn text information into a format that Excel can use.

Step

1

Select The Text To Columns

On the ‘Data’ tab of Excel, select the ‘Text to Columns’ option in the ‘Data tools’ section.

Use Text To Columns

Step

2

Delimited Option

Once you have selected this, the feature will then give you the option to delimiter characters that you have selected to split that data in your spreadsheet. For our purposes, simply keep the ‘delimited’ option selected.

Once you have done this, you will now have the option to select a format that you would have otherwise converted the separated columns into a single format. The latter function also works as a text-to-number formatter in our case.

4

Converting Text To Numbers Format By Multiplying It.

Number text values can still be read and used by Excel in formulas. This process can help us to convert the text format into a numerical one.

Step

1

Select A Cell

On a cell that you want to convert, simply select it and multiply the value of the selected cell by 1.

The process will then convert the cell’s contents into a numbered format.

And because you only multiplied the cell by one, the value of its contents has stayed the same.

Final Thoughts

As you can see, there are many options available for you to use when it comes to converting text to numbers in Excel. Choose the one which best suits you, and you’ll never have to wonder how to do it again.