| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change text to numbers
I have a large spread sheet. I turned on the error checking and checked
numbers stored as text. I highlighted the numbers and clicked on the yellow diamond with the exclamation point and clickee on text to number. Afterwards, I get a message saying "not responding". I also used the cell format command and clicked on number. This also did not work. Is there a way to convert text to number that will not take so long? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change text to numbers
Format all cells to General.
Copy an empty cell. Select all cells and EditPaste Special(in place)AddOKEsc. Gord Dibben MS Excel MVP On Tue, 1 Apr 2008 11:15:01 -0700, TVC wrote: I have a large spread sheet. I turned on the error checking and checked numbers stored as text. I highlighted the numbers and clicked on the yellow diamond with the exclamation point and clickee on text to number. Afterwards, I get a message saying "not responding". I also used the cell format command and clicked on number. This also did not work. Is there a way to convert text to number that will not take so long? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change text to numbers
This worked. Thank you so much.
"Gord Dibben" wrote: Format all cells to General. Copy an empty cell. Select all cells and EditPaste Special(in place)AddOKEsc. Gord Dibben MS Excel MVP On Tue, 1 Apr 2008 11:15:01 -0700, TVC wrote: I have a large spread sheet. I turned on the error checking and checked numbers stored as text. I highlighted the numbers and clicked on the yellow diamond with the exclamation point and clickee on text to number. Afterwards, I get a message saying "not responding". I also used the cell format command and clicked on number. This also did not work. Is there a way to convert text to number that will not take so long? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why won't my cells change from Text to % or Numbers | Excel Discussion (Misc queries) | |||
| How do I Change Numbers in text in MS-Excel | Excel Discussion (Misc queries) | |||
| the numbers are always in text and i cant seem to change them??? | Excel Worksheet Functions | |||
| Change CSV-load cell format from GENERAL to TEXT for numbers? | Excel Discussion (Misc queries) | |||
| change numbers to text | Excel Worksheet Functions | |||
Linear Mode
