One way would be to do a Find$Replace on the file before importing to replace
all hyphens with doublehyphens.....(replace - with --)...........then change
back after importing if you wish..........


Vaya con Dios,
Chuck, CABGx3



"Mike" wrote:

I have a csv file that includes a column that contains text in the format
1-2-14. These are not dates, they are text and must remain in that format. I
have tried importing, pasting, everything I can think of (including the
obvious cell formatting) with no luck. They are converted into dates and I
can't get them back into the right format. Can anyone help?

Thanks in advance
Mike