Convert Text to Numbers in Microsoft Excel

In this article we will learn about how to convert text to numbers in Microsoft Excel.

We all knows that in Excel by default numbers are aligned right side and text are aligned left side to the cell. In this article we will learn how to convert text strings that represent the numbers to numbers.

While importing data into Excel from another software or Internet website, Excel is not able to make any difference in Text & Numeric.

The first indicator of a number that gets converted to Text format is the alignment.

By default, text is left aligned & numbers are right aligned.

img1

To change the text to number, we can use Value Function.

Value: Converts a text string that represents a number to a number

Syntax: =VALUE(text)
To convert number to text, follow the below mentioned steps:

  • Enter apostrophe ( ‘ ) in front of the number in cell A2
  • In cell B2, we have shown 1 by taking a cell reference

img2

To convert the text into number, we will use the Value Function.

  • Cell B2=VALUE(A2)

img3

  • We can also make out the cell that contains text rather than number
  • When we click on cell A2, we will see

img4

  • Click on the pointer that pops up

img5

  • Select Convert to Number

img6

  • We will get the number converted from text

 

Another method to convert text to numbers by using Paste Special command

  • Select the cell containing text
  • Type Ctrl + C to Copy the cell
  • Click on the cell where you want to paste it as value
  • Right click & click on Paste Special
  • Select Values & Add button

img7

  • Click on OK

img8

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.