Try changing your Windows Regional Options (in Control Panel, not in Excel).
--
David Biddulph


"Loris" wrote in message
...
When applying the keyboard shortcut CTRL+SHIFT+# to a number, Excel
formats
that number in the 29-Mar-10 format by default. How do I change that
default
format for the current and all futire workbooks?