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.
9 Replies
- 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
Hi Ivor,
No autoformat here. Aug 16, 2017 is equal to number 42963. You may convert using formulas, macros, or Data->Text to Column
So is it mean that, if I key in 20170830, excel is unable to format it 2017/08/30?
It only able to format it to a unknown date?
Excel recognizes it as 20 million something number, it doesn't know by default you'd like to have something different.
