Change text to numbers

[TVC]

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?

 

[Gord Dibben]

Format all cells to General.

Copy an empty cell.

Select all cells and Edit>Paste Special(in place)>Add>OK>Esc.


Gord Dibben MS Excel MVP

 

[TVC]

This worked. Thank you so much.

Format all cells to General.

Copy an empty cell.

Select all cells and Edit>Paste Special(in place)>Add>OK>Esc.


Gord Dibben MS Excel MVP