Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Ask your geeky hard core Excel questions here!
I have tried changing the format of the cells with the wall street macros. I have gone into the formatting menu and tried many Date variations. I have tried creating my own list, inserting the filter, getting the date filter in place, then copying my data below the few dummy dates. This still did not work. The filter immediately reverted back to only text options.
How do I get excel to recognize a column of dates as Dates and not Text?
Thank you, Read More