Changing a Date into a Value

[Confused_in_Houston]

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...

 

[T. Valko]

Try one of these:

This returns a *text* string:

=TEXT(A1,"yyyymmdd")

This returns a numeric number:

=--TEXT(A1,"yyyymmdd")