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

=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

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

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

I have a problem similar your problem, what I did is I put a message using
Data - Validation -input message.

"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

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

If you want to use the numeric value of this cell, then you can do the
following:

=1*LEFT(C1,LEN(C1)-2)

If you are carrying out arithmetic on the value, then you can omit the
1* bit at the beginning.

Hope this helps.

Pete

On Aug 18, 11:48 pm, 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- Hide quoted text -

- Show quoted text -

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

If you need to reference the formula result in another formula, I suggest
adding a hidden column, putting the formula in that column. That way you can
reference it in the column you want to add text, and in other formulas.

column c contains the formula: =A1+B1+25

column d contains the following: = c1 & "*"

you can then hide column c.


"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