Format date from Text to Date

[aumirink]

I have dates showing up in the text format as Jul 01, 2013 I need to convert to Date format mm-dd-yyyy Please help.</SPAN>

<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>

 

[Jonmo1]

Try copying a blank cell
Highlight the 'text dates'
Right Click - Paste Special - Values - Add - Ok
Now format the cells as a date format of your liking.

 

[Rick Rothstein]

Another way...

1) Press ALT+de to bring up the TextToColumn dialog box
2) Select Delimited and click Next
3) Make sure there are no checkmarks in either the Space or Comma checkbox
4) Click the Finish button
5) Format the cells the way you want