Simple question about formatting

[el_ja]

Hello,
I got (what I think is simple) question.
I'm downloading my credit card statement from amex and it downloads in an excel file.
The problem is that excel doesn't recognize the dates as dates.
This is for example one of the lines:
<table width="444" border="0" cellpadding="0" cellspacing="0"><col width="118"><col width="267"><col width="59"><tr height="17"> <td class="xl63" style="height:12.75pt;width:89pt" width="118" height="17">06/29/2009</td> <td class="xl63" style="width:200pt" width="267">GOODS AND SERVICES </td> <td class="xl63" style="width:44pt" width="59" align="right">-29,00</td> </tr></table>
Now on first look 06/29/2009 is the format I use for dates, but I have to select the cell then press enter and then it changes to 39993 and then I format it as a date and it shows 06/29/2009 again but now excel recognizes it as a date.
I tried changing the format but nothing works until I select the cell and press enter.

The problem is that there's more than 500 lines and I don't want to select and press enter 500 times

Anyone knows how to make it fast?

 

[shg]

Try selecting the column, Data > Text to Columns > Finish

 

[el_ja]

Ah awesome, I knew something simple could be done but couldn't find it :D
Thank you very much.