Faster Way to Convert Text to Number

[Naveed Ul Haq]

Hi Everyone,

I extract data from an ERP and then copy that data into another excel sheet but the problem is that the extracted data is stored as text and I have to manually convert it to number. Its a time taking activity, any faster way to get this sorted???

Regards,

 

[sandy666]

try:
change format of column to General if necessary
use Data - Text to columns (Delimited - Next - Next - Finish)

 

[Rick Rothstein]

use Data - Text to columns (Delimited - Next - Next - Finish)

Your second step works, of course, but I don't think you have to select Delimited nor click Next - Next... I believe you can just click Finish as soon as the dialog box appears and it should work as well.