If you already have the formatting set you should only have to enter the
date such as 1jul which will produce 07/01/2006. If you want any other
year other than 06 you will have to enter the year also as in 1jul04
which would then give you 07/01/2004. Again depends on the way you have
it formatted as to how it appears. Hope this helps.

Ed


--
patele
------------------------------------------------------------------------
patele's Profile: http://www.excelforum.com/member.php...o&userid=35849
View this thread: http://www.excelforum.com/showthread...hreadid=562858