format=Cells=Number Tab, select custom and enter

yyyymmdd

--
Regards,
Tom Ogilvy

"Adam1 Chicago" wrote in message
...
How can I get Excel (2003) to display a date as YYYYMMDD with no hyphens,
periods or dashes between the YYYY the MM and the DD?

I still need the cell to be recognized as a date.

Thanks