Forum Discussion
Does Excel consider date column as text if the number of blank values are more than the date values?
There is absolutely no problem.
The column A Number format is set as custom which you need to change to date.
Select the entire A column (by clicking on A) and change its format to DATE.
That's all.
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.
