Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off automatic date formatting? | Excel Discussion (Misc queries) | |||
remove automatic formatting of new columns in Excel? | Excel Discussion (Misc queries) | |||
Enable Automatic Refresh | Excel Worksheet Functions | |||
How can I find automatic links in an Excel-sheet? | Excel Discussion (Misc queries) | |||
find automatic page breaks | Excel Worksheet Functions |