08-26-2019 01:00 AM
08-26-2019 01:28 AM
Format doesn't matter, dates in Excel are sequential integers where 1 is 01 Jan, 1900. Another story if you have text representation of dates. You may check in any empty cell by =ISTEXT(A1). If it return false, you have dates, otherwise date. Other way, Ctrl+1 on A1 and apply General format to check if you see integer number.
08-26-2019 04:02 AM
This simply means that your dates are not real dates but the dates in text format.
Excel treats dates as real numbers and to check this enter a date in any cell and change it's format to General, the entered date (if a valid date) will be converted to the number underneath it.
The other way to check if a date in any cell is real date or a date as text, assume your date is in A2 then place the formula =ISNUMBER(A2) in any blank cell and if the formula returns True, that means the date in A2 is a real date otherwise it's just a text.
So if the dates in column A and B are not the real dates, you may select whole column A and make a New Rule for conditional formatting using the formula given below and set the format as per your choice.
Please refer to attached with a conditional formatting applied to the column A.
08-26-2019 09:52 AM
I think, Dates as Text entries can be converted into the real dates using the Text to Columns feature if date has the default date separator in it i.e. if the default separator for the date in the regional settings is "/" and the text date uses the "." as date separator, it won't be converted into the real date.
08-26-2019 10:18 AM
It seems that you used Text to Columns and set the format of the column to date in the following step.
I was talking about one step Text to Columns method which works for the dates with the default date separator but entered as Text entries and in that method, you just need to select the date column --> Text to Column and click on Finish in the first step itself.