Excel Date Sort Format: Weekday, Month Day, Year

M

mrsinnister

-Whenever I try to sort data in the format shown Wkdy, Month Day, Year
it reverts to some alphabetical crap by the leftmost item. I hav
2000+ items I have randomly placed in this column and I just need th
thing sorted or a format that will make it work. This shouldn't b
this difficult. Don't tell me I have to delete the weekday or place i
last to make it work.
 
P

Pete_UK

Is the underlying data in Excel time format which youhave just
formatted to give you Dayname, Month Day, Year or are these text
strings?

If in date format, you should be able to highlight the column and
Format | Cells | Date and choose another format from the list (or
Custom Format yyyy mm dd for example). You should now be able to sort
properly, and you can change the format back to how it was, once
sorted.

Hope this helps.

Pete
 
M

mrsinnister

*-I had to manually key in the numeric equivalent of the date after
formating the corresponding column. If there is a way to just convert
text to numeric, in case it happens to someone else, they will
appreciate your solution. Now I know better.-*
 
P

Pete_UK

I've given you two ways of converting the text to values in one of your
other postings.

Pete
 
Top