Can you give an example of how the dates are listed?

1107 = 1/1/07
11107 = 1/11/07 or 11/1/07
111007 = 1/10/07



"MEAD5432" wrote:

I have a column full of various dates that look like: 6/1/07 but they are
typed into the cell as 6107 and an input mask adds the slashes.

Because of this setup, I can't sort the dates.

Is there a way for me to reformat these dates so they can be sorted as dates
without retyping all of them by hand?