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,t...
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?
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.