View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Max Scott[_2_] Max Scott[_2_] is offline
external usenet poster
 
Posts: 1
Default Importing Data - overriding auto format

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