Reformatting dates for sorting
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?
|