I have a spreadsheet that for some reason has dates entered like this:

Col A Col B Col C
10 3 2010....................for October 3, 2010

How can I convert this into a proper date?