Date Format Quandry in EXCEL Closed

Question

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!!!

bigred98 · Answer

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!

JAS105 · Answer

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

Date Format Quandry in EXCEL

2 responses

Similar discussions

Subscribe To Our Newsletter!