Search : in
By :

Date Format Quandry in EXCEL

Last answer on Feb 25, 2009 6:59:00 pm GMT Denise, on Feb 25, 2009 5:48:53 pm GMT 
 Report this message to moderators

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

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « Date Format Quandry in EXCEL » in :
Verifying date format in PHP ShowVerifying date format in PHP There are several ways to check the format of a date in PHP; the simplest method is to make use regular expressions. To confirm a date format DD/MM/YYYY, where the days and/or month can be given as...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Download PDB (Palm DataBase) to DBF Converter ShowDescription The application is designed by WhiteTown Software. PDB (Palm DataBase) to DBF Converter is a tool that allows you to convert PDB files to DBF format easily. Simple and easy to use, the application has been awarded from various popular...
Download VCW VicMan's Database Show
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Ask your question Reply

1

 bigred98, on Feb 25, 2009 6:59:00 pm GMT

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!

   
Reply to bigred98
Ask your question Reply
They need your help