date format

%3CLINGO-SUB%20id%3D%22lingo-sub-2236853%22%20slang%3D%22en-US%22%3Edate%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2236853%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20are%20many%20articles%20telling%20me%20how%20to%20fix%20dates%2C%20after%20excel%20changes%20them.%26nbsp%3B%20Why%20must%20I%20do%20this%20every%20time%3F%26nbsp%3B%20I'm%20looking%20for%20a%20way%20to%20enter%2012%2F25%2F2021%20and%20not%20have%20to%20reset%20it%20to%20my%20way%20after%20excel%20changes%20it%20to%2025-Dec-2021.%26nbsp%3B%20I%20wouldn't%20be%20upset%20if%20it%20changed%20dates%20to%20the%20way%20I've%20told%20Windows%20to%20display%20dates%3B%20it%20picks%20a%20format%20that%20irritates%20me.%26nbsp%3B%20It%20would%20be%20nice%20if%20it%20would%20learn%20my%20way.%3C%2FP%3E%3CP%3EI%20often%20pre-format%20my%20column%20of%20dates%20to%20text%20format.%26nbsp%3B%20This%20is%20a%20workaround%20and%20not%20ideal%20--%20sometimes%20excel%20keeps%20telling%20me%20I%20have%20a%20date%20in%20a%20text%20field.%26nbsp%3B%20Also%20with%20text%20format%2C%20I%20can't%20properly%20sort%20on%20that%20column.%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20any%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2236853%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2236951%22%20slang%3D%22en-US%22%3ERe%3A%20date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2236951%22%20slang%3D%22en-US%22%3EThis%20can%20be%20fixed%20by%20changing%20the%20default%20setting.%20Go%20to%20the%20Control%20Panel%20then%20Clock%2C%20Language%2C%20and%20Region%2C%2C%20then%20from%20the%20appeared%20dialogue%20box%20hit%20the%20Format%20Tab%2C%2C%2C%20first%20is%20the%20Format%20(based%20on%20Country)%20select%20which%20is%20appropriate%2C%20the%20next%20is%20the%20Date%20%26amp%3B%20Time%20Format%2C%2C%2C%20select%20one%20is%20required%20to%20you%20%2C%20finish%20with%20Ok%2C%20close%20Control%20Panel%2C%2C%2C%20and%20better%20Restart%20the%20PC%2FLaptop%2C%2C%20Window%20will%20apply%20the%20New%20Setting%20%E2%98%BA%3C%2FLINGO-BODY%3E
New Contributor

There are many articles telling me how to fix dates, after excel changes them.  Why must I do this every time?  I'm looking for a way to enter 12/25/2021 and not have to reset it to my way after excel changes it to 25-Dec-2021.  I wouldn't be upset if it changed dates to the way I've told Windows to display dates; it picks a format that irritates me.  It would be nice if it would learn my way.

I often pre-format my column of dates to text format.  This is a workaround and not ideal -- sometimes excel keeps telling me I have a date in a text field.  Also with text format, I can't properly sort on that column.

Thanks in advance for any help.

2 Replies
This can be fixed by changing the default setting. Go to the Control Panel then Clock, Language, and Region,, then from the appeared dialogue box hit the Format Tab,,, first is the Format (based on Country) select which is appropriate, the next is the Date & Time Format,,, select one is required to you , finish with Ok, close Control Panel,,, and better Restart the PC/Laptop,, Window will apply the New Setting ☺

@Rajesh-S 

I already have Windows set to the date format I prefer -- happens that it's Windows' default format as well.  Excel will leave my entry alone if I enter it in exactly that format, otherwise, it converts it to European/military (25-Dec or 25-Dec 2020) format.  I don't like it, but I don't have any other choices.  Excel is by far your best application.  It's too bad it has this one ugly wart.