Forum Discussion
Date format issue
I have a simple worksheet and I am trying to format a column for the date. If I enter 061019 I want it to format as 06/10/2019. I have tried the format cell option but it is not formatting correctl...
You must know that Excel stores dates as numbers. 01/01/1900 is stored as 1, 01/02/1900 as 2, and so forth.
To enter 06/10/2019, you may enter 06/10 only and Excel adds the current year 2019 for you.
To enter 06/10/2019, you may enter 06/10 only and Excel adds the current year 2019 for you.
