Date Format Quandry in EXCEL

Closed
Denise - Feb 25, 2009 at 12:48 PM
 JAS105 - Jul 10, 2010 at 01:21 AM
Hello,
I am sorting data on excel and I have encountered a problem that I can't seem to overcome. My column with date information is formated with date-month-year (04-May-08). I need to sort this column by year first and then by month and then by day. Everytime I try I simply get all the days sorted without regard to year. I'm guessing I need to reformat the date but none of the options seem to apply. Thanks in advance. I know there is probably a simple fix for this but I'm just learning this program and I'm stumped!!!

2 replies

I would copy the Year, month, day; to three separate columns. Then sort by, year>month>day.
If you have a lot of data with different dates, try
copy your date column to a blank area then
Data>text to colums this will take the date to the next two columns; re-format the first column to gerneral
your data should look like this
05/04/08 orig col=5, next col=4 next col=2008
hope this helps!
0
TRY GOING TO EACH WORKSHEET
select OPTIONS / TRANSITION AND UNTICK BOTH
TRANSITION FORMULA EVALUATION AND TRANSITION FORMULA ENTRY

NO IDEA WHY BUT NOW ALL MY SPREDSHEETS IN THE WORKBOOK ENABLE ME TO FORMAT 13-Mar-10 without telling me I have formula error

ps dont ask me why
0