Formatting Concantinated cells

[Brian Matlack]

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

Can anyone help me?

Thank

 

[SteveG]

One way,

=TEXT(A1,"0%")&" "&TEXT(B1,"0%")

Dates

=TEXT(A2,"m/dd/yyyy")&" "&TEXT(B2,"m/dd/yyyy")

Just change the formatting in " " to whatever date format you need.

HTH

Stev

 

[Brian Matlack]

Thanks Steve !!

 

[Gord Dibben]

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