This seems like it should be a no-brainer, but I cannot find the answer or a simple solution.
I have multiple 3D workbooks with dates. All dates are formatted as short date -- and the short date in Control Panel > Region > Short Date is aw well: m/d/yy
When I add a column or rows to Excel 2013 in a column that is already formatted at short date, I get the 6-Jun date or 6-Jun-2014.
Using a worksheet date format only works as long as I do not add any rows or columns. Once I do, new entries revert back to the 6-Jun format.
I once read somewhere that there something you have to change in your Personal.xlsx or xlsm workbook.
What's the solution to this problem.
If anyone from Microsoft is reading this ... why do you guys constantly use defaults that no one in the world uses? Don't you test these things against focus groups or ask real users? If you want to use arcane defaults, why can't you make it simple to change a universal default as simple as a date?