Asterisk pointing to a footnote

A

Ace

I have a formula that contains a cell with a number that has an asterisk at
the end which refers the reader to a footnote at the end of the spreadsheet.
Excel is trying to use the asterisk in the equation. Is their a way to tell
Excel that the asterisk is not part of the formula? e.g.,
a1=100
a2=100
a3=100*
a4=100
a5=100
Total=#VALUE!
when what I really want is just =500

Any help will be appreciated.

Thank you.
 
B

Bill Sharpe

Ace said:
I have a formula that contains a cell with a number that has an asterisk at
the end which refers the reader to a footnote at the end of the spreadsheet.
Excel is trying to use the asterisk in the equation. Is their a way to tell
Excel that the asterisk is not part of the formula? e.g.,
a1=100
a2=100
a3=100*
a4=100
a5=100
Total=#VALUE!
when what I really want is just =500

Any help will be appreciated.

Thank you.
Click to expand...

Put the asterisk in a comment. Better yet, put the footnote in the
comment. If you don't want to use comments, insert a column after column
A, reduce its width to one character and put the asterisk there.

Bill
 
B

Bernard Liengme

Excel cannot use footnotes (as distinct from footers)
The asterisk is used by Excel as the multiplication operator
Perhaps inserting a comment might work for you
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove asterisk from column with text only 4
Combining Text From Cells 3
conditional formatting with asterisk 6
How to Find/Replace * (asterisk) in cell content 4
If And/Or statement for comm calc criteria 4
how do i get an asterisk for 1st footnote and numbers after that? 9
asterisk in a cell 2
Add a cell to a fomula already in a cell and keep the formula 4

Top