enter date with year first

[mcgoo]

Need to enter the date as follows 2007/03/26. Excel will not allow that to
happen in any format. What is the trick.

 

[John]

use a custom format yyyy/mm/dd
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[chefmike]

In format enter a custom date like;
yyyy/mm/dd
this should work for you