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.
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.
If I want to format the number become number?
eg: 220157 to 22:01:57
In Excel dates are sequental numbers where 1 is Jan 01, 1900. And time is decimal part of the number, 22:01:52 is equal to about 0.92.
To convert one number to another you have to use some transformation, that's not just formatting.
