Forum Discussion
shetzel
Sep 16, 2020Brass Contributor
Changing date format
I am getting my dates in this format, 2020-09-15 and would like to convert to 09/15/2020, is there a way to do that. I tried all options I have under custom format, but nothing worked. I have attache...
SergeiBaklan
Sep 17, 2020Diamond Contributor
Select column, Data->Text to Columns
On third step
Finish, dates will be as dates in your locale format.
- shetzelSep 17, 2020Brass Contributor
Thanks, that seemed to be the easiest, I had tried before but was selecting other in the second step, not tab.
Thanks so much.
- SergeiBaklanSep 17, 2020Diamond Contributor
shetzel , you are welcome