Basic auto-recognized date format

[Astromere]

First off, using Excel 2010. I'm trying to change the default format for an auto-recognized date. Excel uses auto-recognition to attempt to guess what you are trying to enter in a cell and reformat accordingly, at least when the format for the cell has not been changed from default General. Everything I have read says that this auto-recognition will use the system settings. Excel is properly understanding that I am entering a date when I do "7/14" but for me it's converting it to a custom date formula "d-mmm" and showing "14-Jul". Why and how do I change it? I understand how simple it is to change the format of a cell, but I am just tired of having to.

 

[Datsmart]

This has been discussed here:
http://www.mrexcel.com/forum/showthread.php?t=338646

and here:
http://www.mrexcel.com/forum/showthread.php?t=400287

Sorry, there is no solution. That is just the way Excel was designed to work.

 

[Astromere]

Thanks for the response. Sorry for new-posting old questions