how to sort date in excel

P

pusimani

I have created a data in excel in which one column contains data. I want to
sort the data with respect to the dates entered in the column. It does sort
but the dates are neither in ascending or in descending order. the sorting is
based on the rules of sort in excel. I need the sorting out by date.
 
G

Guest

Hi

If the dates are recognised Excel dates, they will sort correctly. It sounds
like yours are not, though. Post a sample bit of data to show what
information you have in the cells.

Andy.
 
C

Cathy

Highlight all of the columns that you want to be part of your sort (date,
amount, etc) and include your column headings. While the columns are
hightlighted, go to Data/Sort on your main toolbar. You are allowed to sort
by three levels. Select the columns you want to sort by and if you want them
ascending or descending. Click the Okay button. If you are not happy with
the results click Undo and try again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot sort a table containing text 5
Sort Issue Excel 2003 1
Sort The Date at the center of string with VBA 1
Drop Down Sort Button. 2
Multiple Challenging Excel needs.... 0
Automation of scanned file storage based on content 0
How to Sort and Address 1
How do I combine 2 data sets using date? 2

Top