Related:
- Date Format Quandry in EXCEL
- Excel date format dd.mm.yyyy - Guide
- Marksheet format in excel - Guide
- Format factory - Download - Other
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
2 responses
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!
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!
