Sort by Date

Joszoo

New Member
Joined
Nov 14, 2011
Messages
1
I have a spreadsheet containing data drawn from an access database. I want to sort by the date column, which is in dd/mm/yyyy format however I dont have the oldes/newest option on my sort menu. I tried to set the date to general format and found some of the dates returned as numbers i.e. 40656. I can get around the problem by retyping in the data however the spreadsheet contains in excess of 1000 records. Any help would be appreciated.

Jo
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
you need not worry about the number like 40656
as a matter of fact exel saves the dates only like this numbers. what you see as dd/mm/yy oir dd/mmm/yy are only format for viewing purposes

so you can sort as they are.


only thing is to remember
that in USA type regional configuration excel date is entered as
mm/dd/yy
and some other regional set up it is entered
as
dd/mm/yy.
what is your set up.
suppose it is usa type then
11/1/11 is November first and not eleventh January. keep this in mind.
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,220
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top