LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"