Converting multiple numbers saved as text in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Thank you that's much better than copying 1 and paste special multiply.
Which I found after I posted my question.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best Ways to Convert OST to PDF? 4
How Can I Convert MBOX to HTML File? 2
Convert Numbers stored as Text to Numbers 2
Converting numbers stored as dates to text in Excel 1
Columns formatted As Dates Are Exported as a Number to Text 1
Saving Excel 07 as .WK4 1
convert text to number 2
convert text-format number to number in excel 2000%3f 1

Back
Top