Importing Data - overriding auto format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am importing CSV files using a macro. In one column I have data that looks like dates - eg 10-12, 11-09 etc which Excel automtically thinks this is a date and puts Oct-12 or Nov-09 (or their numerical equivalent to be precise) into the cell. Can I override this and tell excel (in VB) that column 1 is text not date

Thanks
 
I believe you would custom format the column "00-00" before the data is
imported.
Mike
Max Scott said:
I am importing CSV files using a macro. In one column I have data that
Click to expand...
looks like dates - eg 10-12, 11-09 etc which Excel automtically thinks this
is a date and puts Oct-12 or Nov-09 (or their numerical equivalent to be
precise) into the cell. Can I override this and tell excel (in VB) that
column 1 is text not date.
 
Back
Top