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?