Hi!
Let me explain:
in cell B2 i enter 190605 and i want it to show as 19-06-05
I made it through custom formatting
But excel (office 365) does not recognize it as date because the value of B2 is 190605.
How can I solve this so I can use B2 for
Thanks in advance
Regards
Peter from Sweden