Automatic error processing?
 

I have a large Excel table filled with the same error:

"Number saved as text" (note: This is translated from my Finnish version, so
it may not be same in English version)

The problem is simply fixed by running the error solver and clicking
"Transform" on every cell. The thing is that there are about 50,000 cells, so
what I need is some kind of macro or something similar that runs the error
checking function through the whole table and automaticly converts the cells.
If I manually convert the cells, the problem manifest on every other Excel
2003 it is opened with, so I must be able to convert it with the error
checking function.

Select an empty cell
edit|copy
select the range of problem cells
edit|paste special|check add



Sutemi wrote:

I have a large Excel table filled with the same error:

"Number saved as text" (note: This is translated from my Finnish version, so
it may not be same in English version)

The problem is simply fixed by running the error solver and clicking
"Transform" on every cell. The thing is that there are about 50,000 cells, so
what I need is some kind of macro or something similar that runs the error
checking function through the whole table and automaticly converts the cells.
If I manually convert the cells, the problem manifest on every other Excel
2003 it is opened with, so I must be able to convert it with the error
checking function.

--

Dave Peterson