How to convert Numbers stored as Text to Numbers in Excel

Download PC Repair Tool to quickly find &A; fix Windows errors automatically

Numbers that are stored atomic number 3 text can cause unscheduled results, especially when you expend these cells in Excel functions such as Meat and AVERAGE because these functions ignore cells that take school tex values in them. So you need to convert numbers stored as textual matter to numbers racket.

How do I change my act stored as textual matter to number?

Select the Excel cells and then click the hint erroneous belief button and blue-ribbon the exchange to numbers option. Or, follow the methods downstairs if that button is not available.

Convert Numbers stored as Textual matter to Numbers in Excel

You can buoy follow any one of these methods downstairs to exchange numbers game stored as text edition to numbers in Microsoft Excel:

Using the Text to column push button
Using Esteem function
Changing the formatting
Use of goods and services Library paste Special and multiply

1] Using the Text to column button

Choose the column OR select one OR more cells, ensure that the cells you have selected are in the same column, or else the process won't work.

Then click the Data tab and click the Text edition to column button.

A Convert text to column wizard panel appears.

Select the Finite option, then click Side by side.

Select Tab as the delimiter, then click Future.

Select General Eastern Samoa the column data format, so click Finish.

2] Victimisation Value serve

You can use the Value function to return the numeric value of the text.

Select a new cellular telephone in a different column.

Eccentric the formula =Value() and internal the parentheses, type a cell reference that contains textbook stored as numbers. In this example, IT's cellular telephone A2.

Press Move into.

Now lay out the cursor at the lower right recession of the cell and drag the fulfill handle down to fill the formula for the other cells.

Then simulate and paste the newly values to the original cell column.

To copy and paste the values to the Original pillar, select the cells with the new formula. Press CTRL + C. Then click the first cell of the original column. Then along the Home tab, click the arrow below Paste, and click Paste special.

On the Paste Special panel, click Values.

3] Ever-changing the format

Select a cell or cells.

Then Press Ctrl + 1 button to open a Format Cells dialogue box.

Then choice any format.

4] Use Paste particular and procreate

If you are converting more than one column of text to Book of Numbers, this is an excellent method to use.

Select a blank cell and type 1 into it.

Then press Press CTRL + C to simulate the cell.

Then select the cells stored atomic number 3 text.

On the Nursing home tab, dog the arrow beneath Paste, then click Paste Particular.

On the Paste Special dialog box, click Multiply.

Then mouse click OK.

Microsoft Excel multiplies each cell by 1, and in doing so, converts the textual matter to numbers.

We hope this tutorial helps you understand how to change over Numbers stored as text to numbers in Excel.

If you have questions about the teacher, let us do it in the comments.

Shantel is a college student studying for BS in Selective information Technology. Her goal is to turn a Database Administrator or a Organization Administrator. She enjoys reading and watching historical documentaries and dramas.