How to convert text to numbers in Excel – 3 quick ways

Here are three easy methods!

Reviewed By: Kevin Pocock

Last Updated on July 15, 2024
You can trust PC Guide: Our team of experts use a combination of independent consumer research, in-depth testing where appropriate - which will be flagged as such, and market analysis when recommending products, software and services. Find out how we test here.

If you want to learn how to convert text to numbers in Excel, you’ve come to the right place.

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.

In this guide, we will talk about how to convert text to numbers in Excel using three different methods. So, without wasting another second, let’s dive in!

1

Change the cell format

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

Step

1

Select the cell with the text

First, select the cell which contains the text which needs to be converted to a number.

Step

2

Convert the text

Now, go to the Home tab, and click on the white box in Number. From the list, select Number. This will convert the text to a number.

2

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

Click on the 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’

From the 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 cell

Select the cell with the text.

Step

2

Use Text to Columns

Now, go to the Data tab, click on Text to Columns, select Delimited, choose General in Column data format, and select Finish.

This will convert the text into numbers.

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 that best suits you, and you’ll never have to wonder how to do it again. If you want to learn more about Excel and its features, give these guides a read:

Kevin is the Editor of PC Guide. He has a broad interest and enthusiasm for consumer electronics, PCs and all things consumer tech - and more than 15 years experience in tech journalism.