Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Text Formatting to the Result of a Formula
- Thread starter iv63
- Start date
Not that I know of.
You may consider putting the [tt]=TEXT(A1,"0.0")[/tt] in one cell, and [tt]x B2[/tt] in the cell just to the right of it. Then you can format B2 whichever way you want.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
You may consider putting the [tt]=TEXT(A1,"0.0")[/tt] in one cell, and [tt]x B2[/tt] in the cell just to the right of it. Then you can format B2 whichever way you want.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
This can be done only for a vanishingly small subset of special cases, namely the exponents (ie SUPERscripts) 1, 2 and 3. The full ASCII character sets contain special characters for superscripted versions of these three digits, able to be generated by keystroke sequences Alt<0185>, Alt<0178> and Alt<0179> respectively (¹ ² ³).
- Status
Similar threads
- Locked
- Question