Forum Discussion
Default Date Format refuses to use system regional settings
As far as I know, dd-mmm and dd-mmm-yy are built-in formats regardless of your regional settings, and Excel will often use them if you enter a date in a cell that does not already have a date format.
If you want dates to display as m/d or mm/dd, you should format the cell(s) that way, either before or after entering the date.
So, any idea how I file a bug report? Because that's as clear a bug as I've ever seen. User uses standard format for their region, Microsoft claims the application uses the OS regionalization, the application clearly recognizes that it's a date, but the application ignores the user and the regionalization and reformats the user's input into an unchangeable default date format the user didn't want. If I typed 15, and Excel turned it into "0x0f" by default, surely we'd all agree that's actually a bug?
You can report it from within Excel: on the Help tab of the ribbon, click Feedback, then click 'Report a problem'.
I suspect that Microsoft will not consider this to be a bug, though.
