Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding superscript in text function
I use text functions all the time to add "active/live" numbers in sentances
within my financial models. Alot of the time I would like to add a superscript to footnote these sentances more. Does any one know how to add superscript to formulas in Excel? Thanks!!! |
#2
|
|||
|
|||
Formulas can't change formatting, including superscripting. You'd have
to use an event macro to replace the formula, and do the character formatting. It's usually easier to use an adjacent column with formatting set to superscript. The column can be made very narrow to contain only the footnote number. In article , "JoeyZaZa" wrote: I use text functions all the time to add "active/live" numbers in sentances within my financial models. Alot of the time I would like to add a superscript to footnote these sentances more. Does any one know how to add superscript to formulas in Excel? |
#3
|
|||
|
|||
Thanks JE... That's what I thought. Shame you can't...
Again thanks "JE McGimpsey" wrote: Formulas can't change formatting, including superscripting. You'd have to use an event macro to replace the formula, and do the character formatting. It's usually easier to use an adjacent column with formatting set to superscript. The column can be made very narrow to contain only the footnote number. In article , "JoeyZaZa" wrote: I use text functions all the time to add "active/live" numbers in sentances within my financial models. Alot of the time I would like to add a superscript to footnote these sentances more. Does any one know how to add superscript to formulas in Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function In A Text Box | Excel Discussion (Misc queries) | |||
Adding text in formulas | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Function within a TEXT FORMULA | Excel Worksheet Functions | |||
using text with a function | Excel Worksheet Functions |