Issue sorting by date
 

I have a user who has a sheet that has dates sorting like this, what can I do
to change it to sort from 1/1/96 thru my last date? I've tried formatting the
columns every way I can think of.

Example:
1/1/1996
1/1/1997
1/1/2000
1/2/1996
1/2/1997
1/2/1999

Issue sorting by date
 

It looks as if your data cells are formatted as text. You need to convert
the text to dates.
--
David Biddulph

"bradsdad25" wrote in message
...
I have a user who has a sheet that has dates sorting like this, what can I
do
to change it to sort from 1/1/96 thru my last date? I've tried formatting
the
columns every way I can think of.

Example:
1/1/1996
1/1/1997
1/1/2000
1/2/1996
1/2/1997
1/2/1999

Issue sorting by date
 

did exactly that. I ended up getting that done but is there an easy way to
know that they were in text? There were approx 13,000 lines.

"David Biddulph" wrote:

It looks as if your data cells are formatted as text. You need to convert
the text to dates.
--
David Biddulph

"bradsdad25" wrote in message
...
I have a user who has a sheet that has dates sorting like this, what can I
do
to change it to sort from 1/1/96 thru my last date? I've tried formatting
the
columns every way I can think of.

Example:
1/1/1996
1/1/1997
1/1/2000
1/2/1996
1/2/1997
1/2/1999

Issue sorting by date
 

If you haven't adjusted the formatting of the cells, the easiest way to spot
it is that by default, text is aligned at the left, while numbers and dates
are aligned at the right.
You can check with ISTEXT(A1).
--
David Biddulph

"bradsdad25" wrote in message
...
did exactly that. I ended up getting that done but is there an easy way to
know that they were in text? There were approx 13,000 lines.

"David Biddulph" wrote:

It looks as if your data cells are formatted as text. You need to
convert
the text to dates.
--
David Biddulph

"bradsdad25" wrote in message
...
I have a user who has a sheet that has dates sorting like this, what can
I
do
to change it to sort from 1/1/96 thru my last date? I've tried
formatting
the
columns every way I can think of.

Example:
1/1/1996
1/1/1997
1/1/2000
1/2/1996
1/2/1997
1/2/1999

Issue sorting by date
 

The data is text.

Select and DataText to ColumnsNextNextColumn Data FormatDateMDY and
Finish.

Should sort by date now.


Gord Dibben MS Excel MVP

On Mon, 29 Jan 2007 13:50:01 -0800, bradsdad25
wrote:

I have a user who has a sheet that has dates sorting like this, what can I do
to change it to sort from 1/1/96 thru my last date? I've tried formatting the
columns every way I can think of.

Example:
1/1/1996
1/1/1997
1/1/2000
1/2/1996
1/2/1997
1/2/1999