retaining font format after text merge

[ivan]

Hello,
I have two pieces of information. One is a number, the
other is a footnote. I need to merge the two together using
the text= command (to preserve my number formatting). When
I merge these together, my footnote, which I have
superscripted in the original cell, does not remain
superscripted. How can I do this?

Maybe text= is not what I want after all? My problem
leading up to using the text= command was that I get
numbers that are anywhere from 0 to 3 significant figures,
but I must report them to 3 significant figures. I also
need to tack on a superscripted footnote every so often _in
the same cell_. I can't use macros. Any ideas?

thanks in advance,
Ivan

 

[Dave Peterson]

can't do the formatting like this with a formula.

See more info at one of your other posts!