Forum Discussion
Does Excel consider date column as text if the number of blank values are more than the date values?
I have a file which has 2 date columns
first column has more blank values than date values due to which the entire column is shown as text when I filter on it.I tried using Format cells ,Datevalue,text(Field,'Date Format') and changed column datatype to date but it still keeps showing as text.
2nd Date column has more date values and it shows as Date when filtered on.
How can this issue be resolved for the first column without using Find and Replace manually?
I have uploaded the file at below link :Excel Link
Also,it does not have any viruses .Please take a look.
6 Replies
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.
