Forum Discussion
Date Field showing as text due to the '-' hyphens present in the field.
So ,I have a date field in date format (Jan-17) and when I filter on that field it keeps showing Text Filters as below instead of date Requirement is to get Date Filters as below : ...
That typically happens when one or more cells do not contain a date (or have not been interpreted by Excel as being a valid date). To find them, select the column in question and press the F5 key on your keyboard (GoTo). Click the Special button. Select "Constants" (or "Formulas" if the cells contain formulas!) and only check the "Text" box. Now you can hit the Del key to empty those cells and you should be able to filter on dates.
- I tried this,however getting message No cells were found for the entire column.
Is there any way to handle the hyphens to show as date using any formula?
Thanks.- Alternatively, do a Find and Replace and replace - with nothing (check the "Match entire cell contents" box)
- Hi,I tried this and it seems to work ,however as this data is exported via ,it will be a manual process.
Also, is this true that Excel consider date column as text if the number of blank values are more than the date values?
I tried using format cells to show as date but it still shows as Text.
