Another way I've used before when data format is uncertain:
- export the data to a Comma-Delimited Text file
- import it in to a new spreadsheet. The import wizard asks you to confirm what's in each column, so you can specify that column is a mm/dd/yyyy date.