I used Bob Phillips example but modified it to read:
=TEXT(B:B,"dd/mm/yyy") & " " & TEXT(C:C,"hh:mm:ss")
as I did not need it for the functionality but for appearance.


"Bob Phillips" wrote:

=TEXT(A1,"dd/mm/yyy") & TEXT(B1,"#,##0.00")

as an example

--

HTH

RP
(remove nothere from the email address if mailing direct)


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