Text Formatting to the Result of a Formula
Text Formatting to the Result of a Formula
(OP)
=TEXT(A1,"0.0")&" x B2"
Is there any "trick" to format text created with this formula – I want number "2" to be exponent (subscript)?
Thanks,
IV
Is there any "trick" to format text created with this formula – I want number "2" to be exponent (subscript)?
Thanks,
IV





RE: Text Formatting to the Result of a Formula
You may consider putting the =TEXT(A1,"0.0") in one cell, and x B2 in the cell just to the right of it. Then you can format B2 whichever way you want.
Cheers,
Joerd
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Text Formatting to the Result of a Formula