Excel 2004 — Number Stored as Text

[Edward Volchok]

I have an important spreadsheet with many "Number Stored as Text"
errors. Excel 2004 allows me to correct this error so the munber is
stored as a number, which I can then use for calculations. That's the
good news. The bad news is that Excel corrects this error one cell at
a time. This is very S L O W.

Is there a way to correct multiple cells with a single command?
Batching this correction is what we need to do. Perhaps someone has
already written a macro. I've tried to record a macro with no success.

Edward Volchok, PhD

 

[JE McGimpsey]

I have an important spreadsheet with many "Number Stored as Text"
errors. Excel 2004 allows me to correct this error so the munber is
stored as a number, which I can then use for calculations. That's the
good news. The bad news is that Excel corrects this error one cell at
a time. This is very S L O W.

Is there a way to correct multiple cells with a single command?
Batching this correction is what we need to do. Perhaps someone has
already written a macro. I've tried to record a macro with no success.

One way:

Copy an empty cell. Select the "text numbers". Choose Edit/Paste
Special, and select the Add and Values radio buttons. Click OK.

Format the cell with a number format as desired.

 

[Guest]

-----Original Message-----
I have an important spreadsheet with many "Number Stored as Text"
errors. Excel 2004 allows me to correct this error so the munber is
stored as a number, which I can then use for calculations. That's the
good news. The bad news is that Excel corrects this error one cell at
a time. This is very S L O W.

Is there a way to correct multiple cells with a single command?
Batching this correction is what we need to do. Perhaps someone has
already written a macro. I've tried to record a macro with no success.

Edward Volchok, PhD
.

 

[Bob Greenblatt]

I believe J.E answered this the other day. However here is another slightly
different method:
In any empty cell, enter a 1. Then copy this cell. Then select the text
cells you want to change. Once they are all selected, go to Edit-paste
special and select multiply. This will force all the text values to numeric
values. Delete the 1 when you are done.