=concatenate(TEXT(A1,"yyyymmdd"),...)
--
David Biddulph

wrote in message
...
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