="Text1"&TEXT(A10,"#,##0.00")&"Text2"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"GeorgeF" wrote in
message ...

I have a calculation inserted within a line of text. I'm using the
following: ="Text1"&A10&"Text2" The Text is printing fine, but how do
I control the number of digits to the right of the decimal that are
displayed by A10? A10 is a calculation of two other cells that
periodically change in value and have variable decimal length.


--
GeorgeF
------------------------------------------------------------------------
GeorgeF's Profile:
http://www.excelforum.com/member.php...o&userid=24124
View this thread: http://www.excelforum.com/showthread...hreadid=486210