Sorting Dates in format "01/19/09"

S

SCH

How do I set my Excel to Always sort dates in the following format by Year,
Month, and Day? My current setting sorts by Month, date, and then year.
For example my setting is sorting as follows:
01/19/09
02/01/08
02/17/08
etc.
 
D

David Biddulph

By the looks of it, you're sorting as text, rather than dates. What
do=ISTEXT(cellref) and =ISNUMBER(cellref) give you for a typical cell in
your range? If you've got text, you'll need to change to dates before
sorting.
 
M

Marcelo

Hello SCH,

dates are numbers in excel and it does not deppend the format you use, it
looks you are working with text, instead of date, if my understand is wrong,
and you have dates as dates not as text, you just need sort descending

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"SCH" escreveu:
 
S

Sean Timmons

If the dates are set as text, you may see green triangles on the top of the
cells. Highlight all of them, click on the yellow exlamation point that
appears, and perform you correction there.
 
R

Ron Rosenfeld

How do I set my Excel to Always sort dates in the following format by Year,
Month, and Day? My current setting sorts by Month, date, and then year.
For example my setting is sorting as follows:
01/19/09
02/01/08
02/17/08
etc.

Most likely your data is stored as TEXT rather than as dates.

To prove this, =ISNUMBER(cell_ref) will give FALSE (if they are stored as dates
it should return TRUE).

To correct this, you can try:
select a blank cell
edit/copy
select your range of dates
edit/paste_special/add

The values may change to 5 digit numbers. Just select to format them as dates.

Now they should sort.

If this does not work, there may be extra characters within the cell.
--ron
 

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

Top