Excel 2004 — Number Stored as Text


E

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
 
Ad

Advertisements

J

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.
 
G

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
.
 
Ad

Advertisements

B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top