Simple question: How do I sort a column by date???

  • Thread starter Thread starter Larry Woods
  • Start date Start date
L

Larry Woods

I have a column that I have defined as "Date" format and all dates are in
the mm/dd/yyyy format. But, when I sort the column it sorts it like text;
e.g., 01/01/2003, 01/01/2004,02/01/2003, etc. How do I tell Excel to sort
the column in date order, not "text" order?

TIA,

Larry Woods
 
Probably your dates are text, rather than "real" Excel dates.
Just to check, format one date as general. If it still shows the date, than
it's text. A date would have shown a number, somewhere around 3800 (today is
day 38001 since 1-1-1900)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
That was it.

Thanks

Larry Woods

Niek Otten said:
Probably your dates are text, rather than "real" Excel dates.
Just to check, format one date as general. If it still shows the date, than
it's text. A date would have shown a number, somewhere around 3800 (today is
day 38001 since 1-1-1900)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
Click to expand...
 
Back
Top