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.
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.