I do not understand how to use the custom format noted in your first reply.

#,##0.00 "*"

Please explain,

Tom

"Gord Dibben" wrote:

I know that and mentioned it in my first reply.

So did you try the Custom Format?

Or the other suggestion?

See Mike's suggestion also.


Gord

On Sat, 18 Aug 2007 15:48:07 -0700, twb111
wrote:

The first formula =A1+B1+25 & " *" does give me 368 *, but I can not use
this cell reference in another formula. This is my prefered results, but i
need to reference the results in other cells.

Thanks, Tom


"Gord Dibben" wrote:

I don't get nekkid with people I don't know so I won't "bare" with you.

=A1+B1+25 & " *" will give you 368 *

Or custom format as I noted.

Rather than a footnote maybe you could try this.

=A1+B1+25+n("the 25 comes from my pocket")

You will see 368 in the cell but in the formula bar you will see the footnote as
well as the formula.


Gord


On Sat, 18 Aug 2007 14:40:00 -0700, twb111
wrote:

I am not followng this. Please bare with me. How do i write the formula with
text so that the I can reference the cell in another formular. My formula is
very basic.

=A1+B1+25 I need to add a footnote to explin the where the number 25 comes
from.
Results I am looking for. 368 *

Thanks, Tom


"Gord Dibben" wrote:


=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