Thread: why does the date 09/01/07 come up as January 9, 2007?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
confused confused is offline
external usenet poster
  
Posts: 193
Default why does the date 09/01/07 come up as January 9, 2007?
When I type September 1, 2007 as 09/01/07 excel formats it to 09-Jan-07. Why
is that? It didn't used to do this, it changed to this recently and I can't
find the option to change it back.
Reply With QuoteReply With Quote