Sometimes the numbers on your worksheet behave strangely; they don’t carry out arithmetic operations as they ought to. This is because, despite their appearance as numbers, they are formatted as text. So, in this article, we will show how to convert text to numbers in * Excel* in 8 different methods.

**Table of Contents**hide

## Download Practice Workbook

You can download the practice workbook from here.

## 8 Easy Ways to Convert Text to Numbers in Excel

In this article, we will discuss how to convert text to numbers in * Excel*. Firstly, we will apply cell formatting. Secondly, we will use the error-checking option. Thirdly, we will use the

*option. Then, we will opt for the*

**Text to Columns***option. After that, we will use*

**Paste Special***. Then, we will simply multiply the data by*

**the VALUE function***to turn them into numbers. Next, we will go for a*

**1***code. Finally, we will use the*

**VBA***to convert text to numbers in*

**Power Query***.*

**Excel**### 1. Applying Cell Formatting

In this method, we will format the cells to hold numbers to convert the data to numbers from text.

**Steps:**

- Firstly, select the cell range containing the text data.
- In this case, it will be
.**C5:C10** - Then, go to the
tab.**Home** - From the
tab, select**Home**.**Numbers** - Finally, from the drop-down choose
.**Number**

- As a result, all the text data will be converted to numbers.

**Read More:** **How to Convert Number to Text in Excel (4 Ways)**

### 2. Using Error Checking

Error checking dialogue box displays any error present in the worksheet. In this instance, we will use that to convert text to numbers.

**Steps:**

- Firstly, select the
cell and you will see the error checking sign beside it.**C5**

- Then, click on the error checking sign, and form the drop-down select
option.**Convert to Number** - As a result,
will turn the text to a number.**Excel**

- Repeat the process for the rest of the data cells.

- Consequently, all the cells will convert to numbers.

**Read More:** **How to Convert Number to Text with Green Triangle in Excel**

### 3. Using Text to Columns Option

In this example, we will use the * Text to Columns* option to convert the text to numbers in excel.

**Steps:**

- To begin with, choose the
cell.**C5** - Go to the
tab.**Data** - Then, select
.**Data Tools** - Finally, from the drop-down, choose
.**Text to Columns** - Consequently, a prompt will appear.

- From the prompt, first, select the
oval.**Delimited** - Then, select
**Next.**

- In the next prompt, check the
box.**Tab** - Again press
.**Next**

- In the final prompt, mark the
box.**General** - Finally, click
.**Finish**

- As a result, the text will be converted to a number.

- Do this for the rest of the data cells.

**Read More:** **How to Convert Number to Text with Commas in Excel (3 Easy Methods)**

### 4. Utilizing Paste Special Option

In this case, we will copy a blank cell and use the * Paste Special* option to paste it into our desired cell to convert the text it contains to a number.

**Steps:**

- Firstly, select the
cell and copy it using the**D5**shortcut.**Ctrl + C**

- Secondly, select the
cell.**C5** - Then, go to the
tab.**Home** - From the
tab, select the**Home**option.**Paste** - Finally, from the drop-down choose the
command.**Paste Special**

- Then, from the
dialogue box, select the oval beside the**Paste Special**option.**Add** - Finally, click
.**OK**

- As a result, the text in the
cell will turn into a number.**C5**

- Repeat the same steps for the rest of the data cells.

**Read More:** **How to Convert Number to Text without Scientific Notation in Excel**

**Similar Readings**

**How to Convert Number to Words in Excel Without VBA****Convert Peso Number to Words in Excel (With Easy Steps)****How to Convert a Numeric Value into English Words in Excel****Convert Number to Words in Excel in Rupees****How to Convert Number to Text and Keep Trailing Zeros in Excel (4 Ways)**

### 5. Applying VALUE Function

A text string that represents a number is changed into a number using * the VALUE function*. In this instance, we will use the function to do it.

**Steps:**

- To begin with, select the
cell and write the following formula in the cell,**D5**

`=VALUE(C5)`

- Then, hit
.**Enter**

- As a result, the function will turn the text into a number.
- Finally, lower the cursor down to the last data cell to auto-fill the cells.

**Read More:** **How to Convert Number to Text in Excel with Apostrophe**

### 6. Multiplying by One

In this case, we will apply a neat mathematical technique to convert texts to numbers.

**Steps:**

- To start with, select the
cell and type the following formula in the cell,**D5**

`=C5*1`

- Then, hit the
button.**Enter**

- Consequently, the formula will turn the text into a number.
- Finally, move the cursor down to the last data cell to auto-fill the cells.

**Read More:** **How to Convert Number to Text with 2 Decimal Places in Excel (5 Ways)**

### 7. Applying VBA

In this method, we will resort to a simple * VBA* code to do the task.

**Steps:**

- Firstly, go to
**the**in the ribbon.*Developer*tab - From there, select the
option.**Visual Basic** - Consequently, the
window will be opened.**Visual Basic**

- After that, in the
tab, click on Insert.**Visual Basic** - Then, select the
option.**Module** - Consequently, a coding module will appear.

- After that, write down the following code in the module and save it.

```
Sub convert_text_to_numbers()
With Range("C5:C10")
.NumberFormat = "General"
.Value = .Value
End With
End Sub
```

- Finally, click on the
tab.**Run** - To run the code, choose the
command from the drop-down menu.**Run**

- Consequently, we will see that
has executed the code.**Excel** - All the texts in the
range will be converted to numbers.**C5:C10**

**Read More:** **Excel VBA: Convert Number to Text with Format (A Total Guide)**

### 8. Applying Power Query

* Power Query* is a fantastic tool for performing any type of necessary data modification. It can also be used to convert text to numbers, without a doubt.

**Steps:**

- Firstly, select the
tab from the ribbon.**Data** - Then, select the
command.**From Table/Range**

- Select the dataset as your table range.
- Finally, click
.**OK** - As a result, the
window will be opened.**Power Query**

- In the
window, select the numerical sign beside the**Power Query**column.**“Salary”** - From the drop-down option, select
.**Whole Number**

- Then, go to the
tab.**Home** - Select the
option.**Close & Load** - Finally, from the drop-down select the
command.**Close & Load** - As a result, a new window will be opened.

- We will see that all the text values are converted to numbers.

**Read More:** **Excel VBA to Convert Number to Text (4 Examples)**

## How to Bulk Convert Text to Number in Excel

In this method, we will bulk convert texts to numbers. We will make use of the * Paste Special* command to do so.

**Steps:**

- Firstly, select the
empty cell and press**D5**to copy it.**Ctrl+C**

- Then, select the cells in the range
and right-click.**C5:C10** - From the available options, select the
command.**Paste Special** - Consequently, the
dialogue box will appear on the screen.**Paste Special**

- From the dialogue box, first, mark the
oval.**Add** - Then, select
.**OK**

- Consequently, all the texts will be turned into numbers in bulk.

## Conclusion

As we can see, there are numerous ways to convert text into numbers in excel. It is best practice to transform text formatted numbers into actual numbers when needed in a mathematical calculation in order to conduct an advanced arithmetic operation.

I have prepare a template in Excel .I want macro instead of goal seek.i want the value in column “”B”” should be such that the computed value of discharge match with the design discharge.i am forwarding the sheet.plz give me help

Thanks for sharing this article. Was very easy to follow. Waiting for more

Using numbervalue function

Thanks a lot for the feedback. I shall input this method when I will update this article later.

Keep it up. Your persistence and hard work is catching my attention. I. will like you to do something on macro. Your step by step method is easy to follow. I have read a lot of materials on macro and understood it but could not get any of my macros to do the task, meaning something is missing. Can you use your detail, honest, pain staking approach to brake

this impasse. I term your style of teaching unique and it will get you to the top.

Thanks for your good words, Dayo!

Best regards

Kawser Ahmed