select the cell

click

Format cells

select "custom" from the Category box
In the "type" box type yyyymmdd

Regards


--
Bonzo123
------------------------------------------------------------------------
Bonzo123's Profile: http://www.excelforum.com/member.php...o&userid=24182
View this thread: http://www.excelforum.com/showthread...hreadid=456961