G
Guest
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?
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?