Excel,Access,SQL Formatting

[Pho3nix]

Hi guys,

Have a date(as text) formated as 01-Jan-12. Now when I try to format it "correctly" to 01/01/12; Excel and Access convert the data to 2001/01/12 even when I've set the format to dd/mm/yy or dd/mm/yyyy. Nothing works. Anyone got any ideas? Data extract link

Thanks

 

[Frikkenator]

Right-click -> Format Cell -> In the number tab, select custom and type in dd-MMM-YY. You should then be able to reference it and show it in another format.

 

[Pho3nix]

Not working , tried it that way and pulling the data using

=DATE(RIGHT(A13,2),MID(A13,4,3),LEFT(A13,2))

but nothing..Get an error aswell.

 

[werfie]

Run the Text to Columns conversion.

Select the column with the dates, Select the Data tab, select Text To columns, Select Next, Select Next, Select Date DMY, select Finish.

Hope it helps.