how do I add text in the same cell with a fomula?
=yourformula & "*"
But you would not be able to use that cell as a reference in another formula
because the cell contents are Text and not numeric to be used in further
calculations.
If you need that cell to remain numeric use a custom format of
#,##0.00 "*"
Gord Dibben MS Excel MVP
On Sat, 18 Aug 2007 13:16:00 -0700, twb111
wrote:
I want to add a footnote reference (*) in the same cell with a formula. I
want the cell formula results to look this.
368 *
Thanks,
Tom
|