The OpenText method allows you to specify the data type of each field. You
would have to specify that this field is text.

To see how this is done first temporarily change the file's extension to TXT
(just so long as it is not CSV). Then record a macro as you open the file
in Excel. The File Import Wizard will appear and you use the third screen
of the wizard to change the field type of the "date" field to Text from
General.

The resulting macro will demonstrate using the FieldInfo parameter to
control data type.



--
Jim Rech
Excel MVP
"Always Learning" <NoMoreSpam@MyEmail wrote in message
...
| 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.
|
|