Hi George

="Text1"&TEXT(A10,"#.00")&"Text2"

Or use some other formatting string; examples can be found in the Format
menu, if you choose Custom

--
Kind regards,

Niek Otten

"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