How to convert text base date into xx/xx/xxxx format

[goodmachine]

I have cells with dates in the format below

<table width="200" border="0" cellpadding="0" cellspacing="0"><colgroup><col width="200"></colgroup><tbody><tr height="17"> <td class="xl24" style="height:12.75pt;width:150pt" width="200" height="17">Wed Jun 01 09:23:11 PDT 2011</td> </tr></tbody></table>
I would like the convert the date to appear as 6/1/2011 instead of the format above. The cell above starts in cell G5 and continues down to G72. Similarly, I have two other columns from H5 and I5 with text based dates down to row 72 as well.

Thanks for any help regarding this matter.

 

[Domenic]

If the format is consistent, try...

=(MID(G5,5,6)&", "&RIGHT(G5,4))+0

...and format the cell as "m/d/yyyy".