Forum Discussion
Excel: How to I autoformat number to standard date format?
Hi, my probem is written as topic. How Excel will autoformat 16082017 to 16/08/2017? I have searched Google for almost two hours and unable to solve it.
Use the Text-To-Columns function in Excel from the Data Ribbon. Make sure when to set the data type to Date that you also select the correct order for the Month-Date-Year. In your sample that appears to be Date-Month-Year or "DMY"
If only you have text as a source, not numbers