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)
