How do I change the date format when importing a txt file?

[Guest]

My import data imports as yyyy/mm/dd even when I tell it to import m/d/y.
When I try to format the column using format cells, custom, mm/dd/yyyy, I get
###########. I tried to change width of column as was suggested in help, but
that does not work. I know I have done this before, but it escapes me now.

 

[Guest]

Just import as pure raw text and then use:

=DATE(LEFT(A1,4)*1,MID(A1,6,2)*1,RIGHT(A1,2)*1)

this will convert 2005/12/25
into 12/25/2005 as a real usable date

 

[Peo Sjoblom]

The whole point when using the text to columns is to import as the format it
comes in and excel will convert it according to your regional settings so if
you get text files with dates like YMD then use YMD in the text to columns
wizard (step 3)and it should be OK


--

Regards,

Peo Sjoblom

My import data imports as yyyy/mm/dd even when I tell it to import m/d/y.
When I try to format the column using format cells, custom, mm/dd/yyyy, I get
###########. I tried to change width of column as was suggested in help, but
that does not work. I know I have done this before, but it escapes me

now.