Feature Request: consistent date interpretation or setting

%3CLINGO-SUB%20id%3D%22lingo-sub-3217121%22%20slang%3D%22en-US%22%3EFeature%20Request%3A%20consistent%20date%20interpretation%20or%20setting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217121%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20using%20excel%20and%20typing%20in%20today's%20date%20using%20my%20System%20Standard%20(US%20dates)%2C%20I%20type%202%2F26%2F2022.%20The%20date%20is%20stored%20properly%20in%20the%20cell%20and%20can%20be%20used%20as%20a%20date.%20It%20displays%20using%20the%20default%20date.%20However%2C%20when%20I%20leave%20off%20the%20year%20and%20only%20type%202%2F26%2C%20Excel%20interprets%20this%20as%20a%20date%2C%20stores%20the%20date%20value%20in%20the%20cell%20and%20then%20changes%20the%20cell%20formatting%20to%20a%20custom%20cell%20formatting%20of%20d-mmm%2C%20so%20my%20date%20gets%20displayed%20in%20the%20cell%20as%2026-Feb.%20Can%20Excel%20add%20a%20feature%20to%20always%20display%20the%20system%20date%20-%20in%20my%20case%202%2F27%2F2022%3F%20Or%20maybe%20make%20it%20a%20workbook%20setting%20so%20that%20dates%20can%20be%20consistent%20throughout%20the%20document%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20some%20examples%3B%3C%2FP%3E%3CP%3Etype%3A%202%2F27%20displays%3A%2027-Feb%3C%2FP%3E%3CP%3Etype%3A%202%2F27%2F22%20displays%3A%202%2F27%2F2022%3C%2FP%3E%3CP%3Etype%3A%202%2F27%2F2022%20displays%3A%202%2F27%2F2022%3C%2FP%3E%3CP%3Etype%3A%2002%2F27%2F2022%20displays%3A%202%2F27%2F2022%3C%2FP%3E%3CP%3Etype%3A%202-27-22%20displays%3A%202%2F27%2F2022%3C%2FP%3E%3CP%3Etype%3A%2027%20feb%20displays%3A%2027-Feb%3C%2FP%3E%3CP%3Etype%3A%2027%20February%202022%20displays%3A%2027-Feb-22%3C%2FP%3E%3CP%3Etype%3A%20February%2027%2C%202022%20displays%3A%2027-Feb-22%3C%2FP%3E%3CP%3Etype%3A%20Sunday%2C%20February%2027%2C%202022%20(not%20treated%20as%20a%20date)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3217121%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3217139%22%20slang%3D%22en-US%22%3ERe%3A%20Feature%20Request%3A%20consistent%20date%20interpretation%20or%20setting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217139%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1318699%22%20target%3D%22_blank%22%3E%40kaycoder%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20is%20not%20the%20best%20place%20for%20feature%20requests.%20Please%20submit%20it%20from%20within%20Excel%2C%20using%20File%20%26gt%3B%20Feedback%20%26gt%3B%20I%20Have%20a%20Suggestion.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

When using excel and typing in today's date using my System Standard (US dates), I type 2/26/2022. The date is stored properly in the cell and can be used as a date. It displays using the default date. However, when I leave off the year and only type 2/26, Excel interprets this as a date, stores the date value in the cell and then changes the cell formatting to a custom cell formatting of d-mmm, so my date gets displayed in the cell as 26-Feb. Can Excel add a feature to always display the system date - in my case 2/27/2022? Or maybe make it a workbook setting so that dates can be consistent throughout the document?

 

Here are some examples;

type: 2/27 displays: 27-Feb

type: 2/27/22 displays: 2/27/2022

type: 2/27/2022 displays: 2/27/2022

type: 02/27/2022 displays: 2/27/2022

type: 2-27-22 displays: 2/27/2022

type: 27 feb displays: 27-Feb

type: 27 February 2022 displays: 27-Feb-22

type: February 27, 2022 displays: 27-Feb-22

type: Sunday, February 27, 2022 (not treated as a date)

1 Reply

@kaycoder 

This is not the best place for feature requests. Please submit it from within Excel, using File > Feedback > I Have a Suggestion.