Hi Alvin

You need to create a custom number via Format\Cells

enter the following - d mmmm yyy


--
BadgerMK
------------------------------------------------------------------------
BadgerMK's Profile: http://www.excelforum.com/member.php...o&userid=31406
View this thread: http://www.excelforum.com/showthread...hreadid=511048