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