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

[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

 

[Niek Otten]

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

 

[Larry Woods]

That was it.

Thanks

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