Excel shortcut for month day year short date closed

Question

Dates are formatted in Excel using the shortcut (CTRL+SHIFT+#) as dd-mm-yy (with month abbreviated). Is it possible to modify the shortcut's format to m/d/yyyy?

Consequently, on August 6, 20016, currently CTRL+SHIFT+# => 6-Aug-16, but how can I get CTRL+SHIFT+# => 8/6/2016?

Answer 1

What about Ctrl-1 + Tab + Tab + Tab + Up (If Ctrl-1 starts you in the Custom Category)

In  Excel 2010:

1. Select both cells 05-Aug-16, 06-Aug-16
2. Ctrl-1 + Tab + Tab + Tab + UpArrow
3. 05/08/2016 , 06/08/2016