I was afraid that was the case. Excel should make that an option in their
next release. I don't see why it is not availible.

"Jim Rech" wrote:

Cell formats are not referencible (if that's a word) by formula. And in
Excel it is simply not possible to give a formula cell a mixed text format
like you want to do. Mixed formats are only possible with pure text
entries. Sorry.

--
Jim
"thanksforthehelp" wrote in
message ...
|I don't know how to link a cell and the formating from one cell to another.
| I am trying to link a cell that has text with a superscript (like k^4).
| Currently, the linked cell would just show it as text (i.e. k4). Can I
| create a smart tag for this? Do I need to make a macro to do this? Can I
| make an autocorrect for this?
|
| Please help!!