# 7. Excel How to convert text to number ?

Normally, when you write a number in a cell, Excel recognises it as a number. However, you may have cells with numbers that Excel considers as text.

If you select such a cell, you will see in the **Formula bar** that the number is preceded by an apostrophe. You can remove the apostrophe from the formula bar and the text is converted to a number.

If you have a cell range with text to convert to numbers, then there are 3 possible solutions:

## Solution 1

Cells with numbers stored as text are marked with a green triangle in the top left corner.

And when you select a range of cells with numbers stored as text, a small yellow diamond appears.

Click on this little diamond and choose **Convert to Number** from the menu that appears.

NB. The selected range can contain cells with other data types, but the selection must start from a cell with a number stored as text.

## Solution 2

Select the cell range containing the texts to be converted to numbers. Use the **Text to Columns** command from the **Data Tools** group on the **Data** tab of the Ribbon.

This starts the Excel **Convert Text to Columns Wizard**. Click on the **Finish** button right away.

## Solution 3

I'll give you a tip in case the two solutions above don't work. Let's take the following example :

Enter the following formula in cell B2 and copy it to column B:

= A2 * 1

The values in column B are numbers. You can copy and paste them into column A with the **Values** option. Then delete the values in column B.