View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NANGO NANGO is offline
external usenet poster
 
Posts: 27
Default Converting multiple numbers saved as text in excel

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?