That suggests you didn't select 'Text' as the import format for column 4.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Paul:

I discovered what I was doing wrong...not selecting ALL columns as text (I was apparently only selecting the default first column as text). When I import now I get exact copy of data from text file and even the leading zeros are retained.

Thanks again.

Keith

I imported csv data, a date, as text. After importing in my spreadsheet, I tried to format the column to a particular date format but it does not seem to work. Any workaround to this?

During data importing, I suspect there cannot be different formats among the columns and is it all one way. I haven't tried but perhaps one could probably import the date separately from the other column data? The later option seems like lots of work to simply obtain a desired date format. Any suggestions welcomed.

I don't think this needs to be a separate thread as it's part of the same issue I posted.

Thanks,
Keith