I have started to use custom formats to display units. For instance when I
want a number to display as 24" or 58.2 lbf. I don't know if this is the
proper way to do this, but it works great for me. The problem is I want one
to display as 28in2 where the 2 is a superscript. Currently I have the
output in one cell and the next cell is text "in2" with the "2" superscripted
to signify inches squared. I would like a solution where I could combine the
two cells into one cell that is still treated as a number when referencing
from other cells.