Rename the file to a .txt file before importing. This should start a wizard in which you can define the types of inputs.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"u473" wrote in message ...
|I import a Cost Code which is structured as such : - ##-##-## (with an
| existing unecessary leading hyphen but that is the way it is)
|
| Unforturnately, MID(ActiveCell,4,8) for 09-04-50 returns a date
| formatted as 9/4/1950 instead of the desired format as 09-04-50.
| I tried to format the column as TEXT before the import, or MID with
| TEXT() in my code without being able to fix the problem.
| The solution is probably simple but I don't have it.
| Help appreciated.
| Celeste