| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SORTING A COLUMN BY DATE
I have a "date" column in my spreadsheet. Is there a way to sort this column
so that the dates are ordered (from earliest to present)? Thanks!! Todd |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SORTING A COLUMN BY DATE
Data/ Sort
[Did you try typing the word "sort" into Excel Help? Help is always worth trying as a first step.] -- David Biddulph "Todd" wrote in message ... I have a "date" column in my spreadsheet. Is there a way to sort this column so that the dates are ordered (from earliest to present)? Thanks!! Todd |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SORTING A COLUMN BY DATE
If real dates, DataSortDescending
Gord Dibben MS Excel MVP On Tue, 19 Feb 2008 08:21:01 -0800, Todd wrote: I have a "date" column in my spreadsheet. Is there a way to sort this column so that the dates are ordered (from earliest to present)? Thanks!! Todd |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SORTING A COLUMN BY DATE
What is the difference between a "real" date and some other kind of date? I
have both 2000 and 2007, and in neither will dates sort properly. I have used the dropdown box that lets you select the date format. I type in, for example, "6/1" and it converts it to "1-Jun". When I sort, I will get some dates correctly sorted; other dates will be out of sequence. This can include things like some of the June dates where they should be and others mixed in with October and December. I have tried using "Custom" rather than date, but that doesn't help. "Gord Dibben" wrote: If real dates, DataSortDescending Gord Dibben MS Excel MVP On Tue, 19 Feb 2008 08:21:01 -0800, Todd wrote: I have a "date" column in my spreadsheet. Is there a way to sort this column so that the dates are ordered (from earliest to present)? Thanks!! Todd |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SORTING A COLUMN BY DATE
A real date is one which Excel rcognizes as a date depending upon your Windows
Regional Settings An entry could look like a date but be text which Excel does not know where to sort. i.e. with Windows regional options set to short date of mm/dd/yyy. An unambiguous date would be entered as 6/1/2008 and return June 1, 2008 1/6/2008 would return January 6, 2008 When you get to entries like 13/1/2008 or 21/5/2008 Excel will treat that as text because there is no month 13 or 21 A real Excel date will have a serial number. You can check by changing the column format to General. Real dates will produce a serial number, text dates will not change. January 6, 2008 will have serial number of 39453 June 1, 2008 will have serial number of 39600 Gord On Sat, 22 Mar 2008 17:30:01 -0700, lindalou wrote: What is the difference between a "real" date and some other kind of date? I have both 2000 and 2007, and in neither will dates sort properly. I have used the dropdown box that lets you select the date format. I type in, for example, "6/1" and it converts it to "1-Jun". When I sort, I will get some dates correctly sorted; other dates will be out of sequence. This can include things like some of the June dates where they should be and others mixed in with October and December. I have tried using "Custom" rather than date, but that doesn't help. "Gord Dibben" wrote: If real dates, DataSortDescending Gord Dibben MS Excel MVP On Tue, 19 Feb 2008 08:21:01 -0800, Todd wrote: I have a "date" column in my spreadsheet. Is there a way to sort this column so that the dates are ordered (from earliest to present)? Thanks!! Todd |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SORTING A COLUMN BY DATE
My numbers seem to be real dates. I get numbers of the sort you just
mentioned. And still, the sorting problem. "Gord Dibben" wrote: A real date is one which Excel rcognizes as a date depending upon your Windows Regional Settings An entry could look like a date but be text which Excel does not know where to sort. i.e. with Windows regional options set to short date of mm/dd/yyy. An unambiguous date would be entered as 6/1/2008 and return June 1, 2008 1/6/2008 would return January 6, 2008 When you get to entries like 13/1/2008 or 21/5/2008 Excel will treat that as text because there is no month 13 or 21 A real Excel date will have a serial number. You can check by changing the column format to General. Real dates will produce a serial number, text dates will not change. January 6, 2008 will have serial number of 39453 June 1, 2008 will have serial number of 39600 Gord On Sat, 22 Mar 2008 17:30:01 -0700, lindalou wrote: What is the difference between a "real" date and some other kind of date? I have both 2000 and 2007, and in neither will dates sort properly. I have used the dropdown box that lets you select the date format. I type in, for example, "6/1" and it converts it to "1-Jun". When I sort, I will get some dates correctly sorted; other dates will be out of sequence. This can include things like some of the June dates where they should be and others mixed in with October and December. I have tried using "Custom" rather than date, but that doesn't help. "Gord Dibben" wrote: If real dates, DataSortDescending Gord Dibben MS Excel MVP On Tue, 19 Feb 2008 08:21:01 -0800, Todd wrote: I have a "date" column in my spreadsheet. Is there a way to sort this column so that the dates are ordered (from earliest to present)? Thanks!! Todd |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SORTING A COLUMN BY DATE
If all your "dates" return a serial number then I have no idea why they should
not sort properly by descending order........earliest to latest. Gord On Sun, 30 Mar 2008 15:58:00 -0700, lindalou wrote: My numbers seem to be real dates. I get numbers of the sort you just mentioned. And still, the sorting problem. "Gord Dibben" wrote: A real date is one which Excel rcognizes as a date depending upon your Windows Regional Settings An entry could look like a date but be text which Excel does not know where to sort. i.e. with Windows regional options set to short date of mm/dd/yyy. An unambiguous date would be entered as 6/1/2008 and return June 1, 2008 1/6/2008 would return January 6, 2008 When you get to entries like 13/1/2008 or 21/5/2008 Excel will treat that as text because there is no month 13 or 21 A real Excel date will have a serial number. You can check by changing the column format to General. Real dates will produce a serial number, text dates will not change. January 6, 2008 will have serial number of 39453 June 1, 2008 will have serial number of 39600 Gord On Sat, 22 Mar 2008 17:30:01 -0700, lindalou wrote: What is the difference between a "real" date and some other kind of date? I have both 2000 and 2007, and in neither will dates sort properly. I have used the dropdown box that lets you select the date format. I type in, for example, "6/1" and it converts it to "1-Jun". When I sort, I will get some dates correctly sorted; other dates will be out of sequence. This can include things like some of the June dates where they should be and others mixed in with October and December. I have tried using "Custom" rather than date, but that doesn't help. "Gord Dibben" wrote: If real dates, DataSortDescending Gord Dibben MS Excel MVP On Tue, 19 Feb 2008 08:21:01 -0800, Todd wrote: I have a "date" column in my spreadsheet. Is there a way to sort this column so that the dates are ordered (from earliest to present)? Thanks!! Todd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
| Sorting a Pivot Table Column that is not the first column... | Excel Worksheet Functions | |||
| How do I limit sorting a column to the column? | Excel Worksheet Functions | |||
| Right column doesn't change when sorting left column. | Excel Discussion (Misc queries) | |||
| Sorting by date when the date isn't exact | Excel Discussion (Misc queries) | |||
Hybrid Mode
