Thread: Formatting a number as a date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Loris Loris is offline
external usenet poster
  
Posts: 39
Default Formatting a number as a date
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?
Reply With QuoteReply With Quote