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

as an example. In other words, pass the format to the text FUNC TION FOR
EACHJ CELL.

--
HTH

Bob Phillips

"GDC" wrote in message
...
If I use the concatenate function or =(cell1)&(cell2), is there a way to
pick
up the formats of the original cells, e.g. underline or strikethru?