Forum Discussion
Does Excel consider date column as text if the number of blank values are more than the date values?
rprsridhar Hi, I have converted the column to Date but the filters still show Text Filters as below :
I want to view the Date Filters here.
Select the last option from the filter.
It will hide all the rows with date (in column A).
Select all the row which is showing - (only column A).
Then press delete button.
Then check. Instead of text filter it will show date filters.
I have checked it with the files you attached. Then it is working.
Cheers.
- Hi,Thank you for checking.However if I delete those values the column B & C data is gone as well which is required.
Is there any way to show the column A as Date without having to delete or Find and replace those hyphen values?As variant you may select entire column A, Ctrl+H and Replace All dashes on zero with matching entire cell content. Apply filter again, it'll Date filter. And 0 will be shown as "-" with your custom number format.
Make sure you are highlighting column A only while deleting.
So that data from column B and C does not get deleted.
It looks like you have imported data from some other source / file.
Some thing has gone wrong there while importing.
I tried what you are asking for but could not succeed.
