Jun 10 2019 08:49 AM
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 correctly. When I choose the date format I want, nothing shows in "sample" and when I type a date in the cell and hit tab, it defaults to 01/27/1967.
What am I doing wrong??
mrsjoan52
Jun 10 2019 08:59 AM
Jun 10 2019 09:08 AM
You are a genius :)
Thank you so much. I never knew this.
mrsjoan52