ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   AUtofiltering dates (https://www.excelbanter.com/excel-discussion-misc-queries/448034-autofiltering-dates.html)

[email protected]

AUtofiltering dates
 
I have a column formatted as dates. I apply an autofilter and the
filter thinks it's a text column. It wants to sort alpahbetically
instead of chronologically.

Any suggestions?

[email protected]

AUtofiltering dates
 
On Mon, 21 Jan 2013 12:59:26 -0500, wrote:

I have a column formatted as dates. I apply an autofilter and the
filter thinks it's a text column. It wants to sort alpahbetically
instead of chronologically.

Any suggestions?


Never mind. The problem was a blank row between the heading and the
data.


All times are GMT +1. The time now is 10:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com