| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting multiple numbers saved as text in excel
Copy a blank cell select your data range right click Paste Special Add
OK "NANGO" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting multiple numbers saved as text in excel
Thank you that's much better than copying 1 and paste special multiply.
Which I found after I posted my question. "Teethless mama" wrote: Copy a blank cell select your data range right click Paste Special Add OK "NANGO" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting multiple numbers saved as text in excel
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 On Wed, 14 Mar 2007 08:04:05 -0700, NANGO wrote: Thank you that's much better than copying 1 and paste special multiply. Which I found after I posted my question. "Teethless mama" wrote: Copy a blank cell select your data range right click Paste Special Add OK "NANGO" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting numbers to text | Excel Discussion (Misc queries) | |||
| Converting numbers stored as dates to text in Excel | Excel Discussion (Misc queries) | |||
| Converting numbers to text | Excel Worksheet Functions | |||
| Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) | |||
| converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) | |||
Hybrid Mode
