MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Converting text to numbers


Posted by MM on October 16, 2001 4:39 AM

Importing numbers from an other application into Excel(simply by copy-paste) somehow converts some of the numbers into text.
How can I convert these "text-cells" back into numbers again?

Thank you in advance,

MM


Posted by Dan on October 16, 2001 5:01 AM

How do you mean it is converting numbers to text? Microsoft Excel automatically converts text to numbers as necessary. Or does "2" somehow become "two"?

Posted by Don C on October 16, 2001 5:19 AM

In a blank cell, type the number 1 and copy that cell. Now, highlight the range of numbers that you imported and go to Edit/Paste Special/Multiply
(Multiply is a check box in the Paste Special box).

Posted by Mark W. on October 16, 2001 6:16 AM

I believe he means 2 becomes "2".

Posted by Jonathan on October 16, 2001 6:41 AM

I think you could also try

=Val(YourCell)

to return a number that's been seen by Excel as Text to be seen as numeric again.

Posted by Mark W. on October 16, 2001 6:44 AM

I presume you are referring to the VALUE worksheet
function, =VALUE(YourCell).

Posted by Jonathan on October 16, 2001 8:54 AM

Yup!

(blush)