Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting by Date, And SUM | Excel Discussion (Misc queries) | |||
insert date | Excel Worksheet Functions | |||
Sorting by date | Excel Discussion (Misc queries) | |||
Sorting Issue (Mixde Fields) | Excel Discussion (Misc queries) | |||
Date conversion issue "^" symbol | Excel Discussion (Misc queries) |