Forum Discussion
How can i convert a value to date format?
Hi, I have a CSV imported file. In this file the date value is captured as 20170424 (representing 24th of April 2017). Excel date format is unable to use this as a date value. Can someone advise ...
No macros!
No formulas!
Go to Data > Text to Columns, then go to step 3, select the following, and then press Finish.
After you finish this process, you can change the date format and make it as you want.
To learn more, please follow this link: