How to Convert Text to Number in Excel (4 Methods)

iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more

There are 4 ways you can convert text to numbers in Excel. This guide demonstrates the 4 ways you can convert texts to number formats.

If you format cells with numbers as Text, it can cause unexpected results. One of the problems you will experience with numbers formatted as text is that you will not be able to sum the numbers. The cell will also display an error message.

To resolve the error, you have to convert the text to a number. Below are the 4 methods to fix this error.

Option 1: Convert Text to Number From the error Message

• Select all the cells with the error message.

• Then click on the error message and select Convert to Number.

To convert the SUM cell:

• Right-click the cell and click Format Cell.

• When the Format Cells option opens, select Number. Then click Ok.

• Next, double-click the SUM cell and press Enter key on your keyboard.

Option 2: Convert Text to Number Using Text to Columns

To use this method:

• Click on top of the column to select the entire column.

• Next, click the Data tab. Then click Data Tools. Finally, click Text to Columns. The Convert Text to column wizard will open.

• Click Finish. The format have been converted. See the second image below.

Option 3: Convert Text to Number Using Formula

You can also use the VALUE() function to convert text to numbers in Excel.

Here is how:

• On a new cell, enter the following formula =VALUE(). Within the (), enter the cell you wish to convert. Then press Enter key.

• To replicate the =VALUE() formula to the other cells, click on C2, then move your mouse towards the bottom right edge of the clicked cell. When the + sign turns black, drag the formula to all the cells you wish to convert.

Option 4: Convert Text to Number Using Paste Special and Multiply

• Enter the number, 1 into a blank cell that does not have the number problem. Select the blank cell with the number, 1. Then Press Ctrl + C on your keyboard to copy the cell. Next, select the cells that have the numbers stored as text.

• Then right-click the selected cells and click Paste Special.

• On the Paste Special options page, select Multiply and click Ok.

Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Support on Ko-Fi

Conclusion

I hope you were able to resolve your Excel error using one of the methods described above.

I also hope you found the Itechguide helpful. If it was helpful, kindly take a moment to leave your comments using the “Leave a Reply” form at the bottom of this page.

Alternatively, you can respond to the “Was this page helpful?” question below.

Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.