View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Always Learning Always Learning is offline
external usenet poster
 
Posts: 25
Default Excel assumes too much

Hi There,

I have a procedure that imports a .csv file.
All was going well until some of the cell values being imported were 17DEC,
28DEC and that made Excel think they are dates and puts into the cell 17-Dec
& 28-Dec, which is wrong, these are actually stock codes.
How do I make sure that when I am processing the data that it stays exactly
as it is in the .Csv file.
Do I have to format the column to be Text before hand? When I tried that it
changed 17DEC into something like 38334

Any help or advice would be appreciated.

Best Regards,

Steve Wilson.