Forum Discussion
Solved
Cannot change some cells to date format in Excel
A downloaded Bank statement refuses to allow some but not all cells to be converted to date formats. I have tried simply to format them as dates converted text to columns using both fixed width ...
Hi jlockley,
There is a high possibility that your computer's date system is in the dd/mm/yyyy format and if so, Excel does not recognize data in the mm/dd/yyyy format as dates. In this case, you can use this formula to extract dates in the dd/mm/yyyy format.
=LET(date, A26:A33, DATE(RIGHT(date, 4), LEFT(date, 2), MID(date, 4, 2)))HTH
IlirU
Hi jlockley,
There is a high possibility that your computer's date system is in the dd/mm/yyyy format and if so, Excel does not recognize data in the mm/dd/yyyy format as dates. In this case, you can use this formula to extract dates in the dd/mm/yyyy format.
=LET(date, A26:A33, DATE(RIGHT(date, 4), LEFT(date, 2), MID(date, 4, 2)))HTH
IlirU