Convert text to numbers.

  • Thread starter Thread starter Danny
  • Start date Start date
D

Danny

Is there a way to convert numbers ENTERED AS TEXT to
ACTUAL NUMBERS so I can easily add the columns?

Thanks
 
In an empty cell, enter the number 1. Edit>Copy. Select your "numbers".
Edit>Paste Special, check Multiply.

--
Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Danny, copy a blank cell, then select the range you want to change and edit,
paste special, add, and click OK
--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Try this Danny

Copy a empty cell
Select the cells with text numbers
Right click on the selection
Choose Paste Special
Check Add
Ok
 
Worked perfectly. Thanks a lot.
-----Original Message-----
In an empty cell, enter the number 1. Edit>Copy. Select your "numbers".
Edit>Paste Special, check Multiply.

--
Kind Regards,

Niek Otten

Microsoft MVP - Excel



.
Click to expand...
 
Thanks everybody! Both ways worked perfectly!
-----Original Message-----
Danny, copy a blank cell, then select the range you want to change and edit,
paste special, add, and click OK
--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **




.
Click to expand...
 
Back
Top