Calculation within Text
On Fri, 18 Nov 2005 09:28:46 -0600, GeorgeF
wrote:
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.
Take a look at the TEXT worksheet function HELP information. You can use any
acceptable 'custom' format.
eg:
="Text1"& TEXT(A10,"0.00") &"Text2"
--ron
|