Hi,
I have a small CSV in which the information in the first column (dates) imports as, e.g., Thu Jul 01 2021 in 'General' number format. I'd like to convert information in this column to dates of any recognizable style (short, long, does not matter). Changing number format does not alter the text whatsoever.
I've also tried text-to-columns and deliminating by spaces, then concatenating to create dates. No luck.
Any help is appreciated! Sorry if this has been asked before.
I have a small CSV in which the information in the first column (dates) imports as, e.g., Thu Jul 01 2021 in 'General' number format. I'd like to convert information in this column to dates of any recognizable style (short, long, does not matter). Changing number format does not alter the text whatsoever.
I've also tried text-to-columns and deliminating by spaces, then concatenating to create dates. No luck.
Any help is appreciated! Sorry if this has been asked before.