Thread: Calculation within Text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GeorgeF
 
Posts: n/a
Default Calculation within Text

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

Reply With QuoteReply With Quote