Home

Date format issue

%3CLINGO-SUB%20id%3D%22lingo-sub-680785%22%20slang%3D%22en-US%22%3EDate%20format%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-680785%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20simple%20worksheet%20and%20I%20am%20trying%20to%20format%20a%20column%20for%20the%20date.%26nbsp%3B%20If%20I%20enter%20061019%20I%20want%20it%20to%20format%20as%2006%2F10%2F2019.%26nbsp%3B%20I%20have%20tried%20the%20format%20cell%20option%20but%20it%20is%20not%20formatting%20correctly.%26nbsp%3B%20When%20I%20choose%20the%20date%20format%20I%20want%2C%20nothing%20shows%20in%20%22sample%22%20and%20when%20I%20type%20a%20date%20in%20the%20cell%20and%20hit%20tab%2C%20it%20defaults%20to%2001%2F27%2F1967.%3C%2FP%3E%3CP%3EWhat%20am%20I%20doing%20wrong%3F%3F%3C%2FP%3E%3CP%3Emrsjoan52%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-680785%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-680820%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20format%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-680820%22%20slang%3D%22en-US%22%3EYou%20must%20know%20that%20Excel%20stores%20dates%20as%20numbers.%2001%2F01%2F1900%20is%20stored%20as%201%2C%2001%2F02%2F1900%20as%202%2C%20and%20so%20forth.%3CBR%20%2F%3ETo%20enter%2006%2F10%2F2019%2C%20you%20may%20enter%2006%2F10%20only%20and%20Excel%20adds%20the%20current%20year%202019%20for%20you.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-680841%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20format%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-680841%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20are%20a%20genius%20%3A-)%3C%2FP%3E%3CP%3EThank%20you%20so%20much.%26nbsp%3B%20I%20never%20knew%20this.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emrsjoan52%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-680844%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20format%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-680844%22%20slang%3D%22en-US%22%3EYou%E2%80%99re%20very%20much%20welcome!%3C%2FLINGO-BODY%3E
mrsjoan52
New Contributor

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

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

You are a genius :-)

Thank you so much.  I never knew this.  

 

mrsjoan52

You’re very much welcome!