Brian

Here is an example the covers both % and date

="Payment due on " &TEXT(D1,"mmmm, d yyyy") & " " & TEXT(A1,"0.00%")


Gord Dibben MS Excel MVP


On Mon, 7 Aug 2006 14:51:54 -0400, Brian Matlack
wrote:


Hi!
How can I retain the formatting on data from several cells combined
into one cell? For Example:
Cell A1 = 6.0% and B1 = 59.0% cell C1 formula is =A1&" "&B1 but it
displays like this 0.05952 0.509118 (it actualy carries-out 17 decimal
places).
I have the same problem with dates.

Can anyone help me?

Thanks