Hi
use something like
=A1 & TEXT(A2,"YYYY/MM/DD")

--
Regards
Frank Kabel
Frankfurt, Germany

"DaveAg02" schrieb im Newsbeitrag
...
I've been using the concatenate function in Excel to make text
strings out of
multiple cells, and I'm trying to do so for cells that include dates
and
times. When I concatenate these cells and they are converted to text,
I get
the general number format for the dates and times instead of the
formatted
date or time that I've entered. Is there a way to avoid this?