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