View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sql_dba sql_dba is offline
external usenet poster
 
Posts: 1
Default 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