Formatting Concantinated cells

B

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
 
S

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
 
G

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
 
Top