Discussion Format text in an equation in Excel
https://techcommunity.microsoft.com/t5/excel/format-text-in-an-equation/m-p/2385026#M101184
<P>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:</P><TABLE width="603px"><TBODY><TR><TD width="602px" height="30px"> =" -"&TEXT(C17,"#.##")&"x"&TEXT(C18,"#.##")&"^4x(5+"&TEXT(C21,"0.##")&")" </TD></TR></TBODY></TABLE><P>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.</P><P>Thanks.</P>Tue, 25 May 2021 19:11:26 GMTpats240z2021-05-25T19:11:26ZFormat text in an equation
https://techcommunity.microsoft.com/t5/excel/format-text-in-an-equation/m-p/2385026#M101184
<P>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:</P><TABLE width="603px"><TBODY><TR><TD width="602px" height="30px"> =" -"&TEXT(C17,"#.##")&"x"&TEXT(C18,"#.##")&"^4x(5+"&TEXT(C21,"0.##")&")" </TD></TR></TBODY></TABLE><P>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.</P><P>Thanks.</P>Tue, 25 May 2021 19:11:26 GMThttps://techcommunity.microsoft.com/t5/excel/format-text-in-an-equation/m-p/2385026#M101184pats240z2021-05-25T19:11:26ZRe: Format text in an equation
https://techcommunity.microsoft.com/t5/excel/format-text-in-an-equation/m-p/2385138#M101194
<P><LI-USER uid="1062996"></LI-USER> </P>
<P>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.</P>Tue, 25 May 2021 19:59:00 GMThttps://techcommunity.microsoft.com/t5/excel/format-text-in-an-equation/m-p/2385138#M101194Hans Vogelaar2021-05-25T19:59:00ZRe: Format text in an equation
https://techcommunity.microsoft.com/t5/excel/format-text-in-an-equation/m-p/2385250#M101201
<P><LI-USER uid="127945"></LI-USER> </P><P> </P><P>Thanks for the reply.</P>Tue, 25 May 2021 20:23:55 GMThttps://techcommunity.microsoft.com/t5/excel/format-text-in-an-equation/m-p/2385250#M101201pats240z2021-05-25T20:23:55Z