Converting multiple numbers saved as text in excel

N

NANGO

I have a spreadsheet with 21000 rows and 6 columns that I have downloaded.

Throughout the spreadsheet there are cells in which numbers are saved as
text that I need to convert to numbers in order to utilize the data.

I can only figure out how to convert one cell at a time. Is there a way to
do this more quickly?
 
T

Teethless mama

Copy a blank cell > select your data range > right click Paste Special > Add
 
N

NANGO

Thank you that's much better than copying 1 and paste special multiply.
Which I found after I posted my question.
 
G

Gord Dibben

The only thing you have to watch for is that the blank cell you copy is
formatted as General, not text.


Gord Dibben MS Excel MVP
 
Top