Date problems when exporting from Quickbase

[GeorgeBryant]

I am exporting a table of results from Quickbase that contains several date fields. When I open the csv file, I see that some dates come in as text and others as dates. The only pattern I can see is that dates where the 'day' is less than 13 seem to come in as dates and those greater than 12 are coming in as text (see below) I tried using the "DateValue" function but I get a "#VALUE! error. I even tried breaking up the test into chunks with the LEFT function, but since the data is mixed between text and dates, this doesn't always work. I can probably come up with a lengthy 'work around' but I am guessing there is a far more elegant solution out there that is beyond my grasp!! Can one of you Excel Guru's help (I'm not worthy, I'm not worthy!)[TABLE="width: 191"]
<tbody>[TR]
[TD] 05-28-2013
[/TD]
[/TR]
[TR]
[TD]08-23-2013
[/TD]
[/TR]
[TR]
[TD="align: right"]09/11/2013
[/TD]
[/TR]
[TR]
[TD="align: right"]09/12/2013
[/TD]
[/TR]
[TR]
[TD="align: right"]04/12/2013
[/TD]
[/TR]
[TR]
[TD]04-22-2013
[/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

Try this:
Select the range or column you need to change.

Go to menu - DATA
-Text to Columns
-Next
-Next
Then choose DATE
-Finish

 

[GeorgeBryant]

Try this:
Select the range or column you need to change.

Go to menu - DATA
-Text to Columns
-Next
-Next
Then choose DATE
-Finish

Thanks - I actually found the 'source' of the issue. Quickbase is set for the US format for dates (day-month-year) and my computer was set for Canadian (month-day-year); for some reason, this caused a mismatch of dates being accepted (that's why records with a day greater than 12 were coming in as text). Very odd and very frustrating but by changing my laptop to the US format I am able to work with the data. Thanks again for your help!