 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / April 2007Autofilter Issue
Autofiltering Dates - stored as string Is there a way to Autofilter a column of dates, when these dates are stored as strings?. 15 Apr 2007 15 Apr 2007 15 Apr 2007 16 Apr 2007 16 Apr 2007 17 Apr 2007 17 Apr 2007 17 Apr 2007 When I set the Custom Autofiler, using 'does not equal' and then selecting '16 Apr 2007' from the drop-down list, this has no effect. When I return to the Custom Autofiler dialog I notice that the criertia has been changed to 39188. The format of the cells are set to text, but Excel will not leave the criteria as a string it converts it to a number - can this be stopped? If not how do I filter my range of text dates only showing thoese which match a criteria which is a valid date as a string? Pre-format cells as Text or enter ' before date. > Autofiltering Dates - stored as string > [quoted text clipped - 20 lines] > If not how do I filter my range of text dates only showing thoese > which match a criteria which is a valid date as a string? Wow, that's weird. I can't get it to work either. If you select Equals 16 Apr 2007 it works. However, if you select Doesn't Equal 16 Apr 2007 it doesn't work. Is it possible to change that field (column) to a numeric field rather than text? That way everything would work normally. > Autofiltering Dates - stored as string > [quoted text clipped - 20 lines] > If not how do I filter my range of text dates only showing thoese > which match a criteria which is a valid date as a string? I wish! Does any mVP or anyone one from Microsoft have a solution? > Is it possible to change that field (column) to a numeric > field rather than text? That way everything would work normally. Put 1 in an empty cell, format the cell as a date, copy the cell select all text dates, do edit>paste special and select multiply  SignatureRegards, Peo Sjoblom >I wish! > > Does any mVP or anyone one from Microsoft have a solution? > >> Is it possible to change that field (column) to a numeric >> field rather than text? That way everything would work normally. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.