If the date is entered as value, custom it in the number format as YYYYMMNN.

Confused_in_Houston wrote:
I have cells that contain dates in the format 2008-04-07. I want to convert
that to 20080407. I've tried RIGHT and MID functions but it works with the
integer that underlies the date. I've cut the date and pasted it as a value
but it again reverts to the underlying integer.

How can I convert a date like 2008-04-07 to a value 20080407?

Thanks...