SOLVED

Format text in an equation

%3CLINGO-SUB%20id%3D%22lingo-sub-2385026%22%20slang%3D%22en-US%22%3EFormat%20text%20in%20an%20equation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2385026%22%20slang%3D%22en-US%22%3E%3CP%3EWindows%2010%20with%20Excel%20365.%20I%20am%20trying%20to%20do%20a%20calculation%20sheet%20where%20I%20write%20out%20the%20equation%20in%20generic%20form%2C%20such%20as%26nbsp%3B'-q*r%5E4(5%2Bv)%26nbsp%3B%20(The%204%20is%20easily%20formatted%20as%20a%20superscript%20in%20Excel%2C%20but%20it%20doesn't%20translate%20that%20way%20on%20this%20forum)%2C%20then%20%22solve%22%20the%20equation%20by%20filling%20in%20the%20values%2C%20for%20example%3A%3C%2FP%3E%3CTABLE%20width%3D%22603px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22602px%22%20height%3D%2230px%22%3E%26nbsp%3B%20%26nbsp%3B%3D%22%20-%22%26amp%3BTEXT(C17%2C%22%23.%23%23%22)%26amp%3B%22x%22%26amp%3BTEXT(C18%2C%22%23.%23%23%22)%26amp%3B%22%5E4x(5%2B%22%26amp%3BTEXT(C21%2C%220.%23%23%22)%26amp%3B%22)%22%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EIs%20there%20a%20way%20to%20format%20the%20solved%20equation%20so%20that%20the%204%20is%20a%20superscript%20instead%20of%20using%20%5E4%20%3F%20Excel%20grays%20out%20the%20format%20function%20when%20editing%20the%20equation.%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2385026%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2385138%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20text%20in%20an%20equation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2385138%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1062996%22%20target%3D%22_blank%22%3E%40pats240z%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENo%2C%20that%20is%20not%20possible.%20If%20a%20cell%20contains%20a%20formula%2C%20any%20formatting%20applies%20to%20the%20result%20as%20a%20whole.%20You%20cannot%20format%20part%20of%20the%20result%20differently%20from%20the%20rest.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2385250%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20text%20in%20an%20equation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2385250%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20reply.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Windows 10 with Excel 365. I am trying to do a calculation sheet where I write out the equation in generic form, such as '-q*r^4(5+v)  (The 4 is easily formatted as a superscript in Excel, but it doesn't translate that way on this forum), then "solve" the equation by filling in the values, for example:

   =" -"&TEXT(C17,"#.##")&"x"&TEXT(C18,"#.##")&"^4x(5+"&TEXT(C21,"0.##")&")" 

Is there a way to format the solved equation so that the 4 is a superscript instead of using ^4 ? Excel grays out the format function when editing the equation.

Thanks.

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@pats240z 

No, that is not possible. If a cell contains a formula, any formatting applies to the result as a whole. You cannot format part of the result differently from the rest.

@Hans Vogelaar 

 

Thanks for the reply.