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