Converting date into text format

[db_murray]

This is related to my previous post.

I need to convert a date in yyyymmdd format to text.

i,e, 20080421 converts to the number 39559 when added to a
CONCATENATE function.

is there a way for the 20080421 to be added to the CONCATENATE
function instead of the raw Excel date number?

Thanks,

Dan

 

[David Biddulph]

=concatenate(TEXT(A1,"yyyymmdd"),...)