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.
<tbody>
</tbody>
A | B |
1957-1-2 | 1957-01-02 |
1957-6-21 | 1957-06-21 |
1957-12-1 | 1957-12-01 |
1957-11-11 | 1957-11-11 |
<tbody>
</tbody>