|
Les types de fichiers classiques ne pourront plus être utilisés à partir de janvier 2021. Vous pouvez transférer vos fichiers classiques ou télécharger un PDF. En savoir plus

Superscript formatting within a formula

Répondu
Demande de démonstration

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

Commentaires

1 commentaire

Date Votes
  • 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

Vous devez vous connecter pour laisser un commentaire.