Reformatting dates for sorting

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
And on top of Barb's questions:

is 1/11/07
January 11, 2007
or
November 1, 2007
or
even worse...
January 7, 1911
or
January 7, 2011???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort imported date column 7
Sorting Date Column 1
retain custom date format "text" when pasting or reformatting data 2
How can I save a sort order for re-use instead of having to type i 1
Change Date format 3
sort date 2
Sort Dates 11
Sorting Cells that contain an Array as Dates 1

Back
Top