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?

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

On Tue, 1 Apr 2008 11:15:01 -0700, TVC <(E-Mail Removed)> 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?

This worked. Thank you so much.

"Gord Dibben" wrote:

> 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
>
> On Tue, 1 Apr 2008 11:15:01 -0700, TVC <(E-Mail Removed)> 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?
>
>