Forum Discussion
extreme noob converting text to date
i am trying to setup a simple spreadsheet. When I enter the date, i prefer to type it in as follows using todays date 08182020. i would like to change that to show as 08/18/2020. I have tried usi...
It appears my previous response was eaten.
I suspect your issue with text to columns is that the date is not actually text, but numeric (custom formatted to show a leading zero).
Try this (change cell reference as needed):
=DATE(RIGHT(A1,4),LEFT(A1,LEN(A1)-6),MID(A1,LEN(A1)-5,2))