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?

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?

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?