enter date with year first
 

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

enter date with year first
 

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)


"mcgoo" wrote:

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

enter date with year first
 

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

"mcgoo" wrote:

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