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