Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |