Convert inconsistent dates in General format to specific date format

[Nola111]

Is there one formula that could be used in all of column B to convert data that looks like the data in column A, into column B? Column A's current format is General. The resulting format of column B can be Date, but does not have to be. If the Length of column A were consistent, I would not have a problem coming up with the formula, but because the lengths vary, and in different places, I'm struggling with coming up with a solution.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1957-1-2[/TD]
[TD]1957-01-02[/TD]
[/TR]
[TR]
[TD]1957-6-21[/TD]
[TD]1957-06-21[/TD]
[/TR]
[TR]
[TD]1957-12-1[/TD]
[TD]1957-12-01[/TD]
[/TR]
[TR]
[TD]1957-11-11[/TD]
[TD]1957-11-11[/TD]
[/TR]
</tbody>[/TABLE]

 

[SpillerBD]

DATEVALUE doesn't work for you?

 

[Dave Patton]

Try formatting to your preference.
Try A2+0 and format to your date preference.

Excel 2010
	A	B
1
2	02-01-57	2-Jan-57
3	21-06-57	21-Jun-57
4	01-12-57	1-Dec-57
5	11-11-57	11-Nov-57
6
2b

Cell Formulas
Range	Formula
B2	=A2+0
B3	=A3+0
B4	=A4+0
B5	=A5+0

 

[Rick Rothstein]

Assuming you want text values returned, this works for me...

=TEXT(A1,"yyyy-mm-dd")

Otherwise use Dave's suggestion in Message #3 .

 

[Nola111]

Wow, all three of these solutions work! I can't believe there were this many ways to go about it and I didn't think of any of them. Thank you @RickRothstein, @DavePatton and @SpillerBD!

 

[SpillerBD]

and all better than the mega-formula that parses the text.
Not recommended, but is...

=DATE(LEFT(A1,FIND("-",A1)-1),MID(A1,FIND("-",A1)+1,FIND("-",A1,FIND("-",A1)+1)-FIND("-",A1)-1),RIGHT(A1,LEN(A1)-FIND("-",A1,FIND("-",A1)+1)))