Simon
change cell format to ddd dd mmm
or for a formula format use =TEXT(A1,"ddd dd mmm")
--
mudraker
------------------------------------------------------------------------
mudraker's Profile:
http://www.excelforum.com/member.php...fo&userid=2473
View this thread:
http://www.excelforum.com/showthread...hreadid=523367