|
Klasyczne typy plików nie są już dostępne od stycznia 2021 r. Możesz przenieść swoje klasyczne pliki lub pobrać plik PDF. Dowiedz się więcej

Superscript formatting within a formula

Udzielono odpowiedzi
Zamów wersję demonstracyjną

I have been unable to utilize the superscript format within a formula. The formula is an if statement that dynamically creates row titles based on the values in other columns (e.g. "realized gains" when all positive amounts vs "realized gains (losses)" when some amounts are positive and some are negative). I have highlighted the footnote reference portion of the title (e.g. (b)) and then tried to format that with superscript but it doesn't keep that formatting once I hit enter. Is there a way to do this?

0

Komentarze

Komentarze: 1

Data Głosy
  • Mike Davis

    Hello and welcome to the community, Eileen!

    The answer is both no, and yes. Today superscript formatting doesn't flow through a formula (nor would bold or italics), so that bit isn't possible. However, a symbol would flow through, so you can insert the symbol for a superscript letter b into you formula and that should flow. To get a symbol in, if its not available from the Insert > Symbol menu (superscript letters are no, only some numbers) you need to create the symbol in another application, copy it, and paste it in. Commonly you do this in Word using a unicode insert method. For superscript letter b, for example, it would be code 1D47. Here's some steps to insert unicode in Word:

    1. Open a blank document in MS Word
    2. In text, type Alt+1D47
    3. The superscript symbol should appear: ᵇ
    4. Copy and paste into Workiva

    Here's an article with the codes for other superscript and subscript characters: https://unicode-table.com/en/sets/superscript-and-subscript-letters/

    Hopefully this helps some. Do let me know if you have any questions about these steps or need any further help. Thanks again and have a super day!

    0

Zaloguj się, aby dodać komentarz.