Formatting Concantinated cells
 

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


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=569116

Formatting Concantinated cells
 

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

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=569116

Formatting Concantinated cells
 

Thanks Steve !!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=569116

Formatting Concantinated cells
 

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