Good morning,
I got a new data set but the dates appear as text a not date - March 25, 2022 (it comes as Month, Day, Year format).
I was trying to convert them to date by using the text to columns function but it only managed to convert the earliest data from Mar to May to dates but the latest rows ( Jun & Jul) were kept in text format.
Does anybody have any idea why it isn't converting the entire column to dates or is there a better way to execute this?
Thank you,
I got a new data set but the dates appear as text a not date - March 25, 2022 (it comes as Month, Day, Year format).
I was trying to convert them to date by using the text to columns function but it only managed to convert the earliest data from Mar to May to dates but the latest rows ( Jun & Jul) were kept in text format.
Does anybody have any idea why it isn't converting the entire column to dates or is there a better way to execute this?
Thank you,