View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lil_gigi
 
Posts: n/a
Default How to display yy/mm/dd 06/03/04 in excel and not get 06/02/2065!

I need to display dates in excel by yy/mm/dd but when I apply this custom
number format to cell, it messes up and gives me wacky dates..

EX: If I enter 06/03/04 in excel I get get 06/02/2065!! I wonder if this has
to do with 2006 being entered as 06 and the first 0 is not recognized??

Anyone got any suggestions!!

Thanks
PS: The date MUST be separeted with / and not - inorder to be consistant all
the company's programs & reports.