Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to fast format cells?
Hello all,
I am DBA and not very knowledgeable in Excel. Currently I am working with large Excel files that have to be imported into database tables. The problem: All contents are formatted as General. I have 2 types of values in same column First scenario: 1 cell :899990 2 cell :899990AB When I import it to database 1 cell is imported as 899990 2 cell is imported as NULL Second scenario: 1 cell :899990AB 2 cell :899990 When I import it to database 1 cell is imported as 899990AB 2 cell is imported as NULL I understood that If the first cell is number Excel assumes that all others are numbers as well and vice versa. We wrote macro that would go to each cell add empty space and format it as text and does it for each file on the given directory. It worked fine, but for 23 files, 599999 lines each it took 10 days for this macro to run and I need it to be done at least for 2 days. Is there any other way to reformat each cell. Thank you in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why will my cells not format? | New Users to Excel | |||
How can I find and format specific cells automatically in Excel? | Excel Worksheet Functions | |||
Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
format cells dialog box does not come up | Excel Discussion (Misc queries) |