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!
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies