Asterisks in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I add an asterisk (for reference purposes only) at the end of a
number (currency) in a cell containing a formula. I do not want the asterisk
to be interpreted as part of the formula. I have Excel 2002 and Windows XP
Professional. Please advise. Thank you.
 
How can I add an asterisk (for reference purposes only) at the end of
a number (currency) in a cell containing a formula. I do not want the
asterisk to be interpreted as part of the formula. I have Excel 2002
and Windows XP Professional.
Click to expand...

One way is to use
Format > Cells > Custom
and use
_($* #,##0.00_)\*;_($* (#,##0.00)\*;_($* "-"??_);_(@_)
as the "Type."
 

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

Asterisk pointing to a footnote 3
Finding asterisks 2
Asterisk is missing from list 2
Remove asterisk from column with text only 4
find asterisk 4
Replacing all asterisks in Excel 2003 spreadsheet 3
*or footnote cells in a table? 2
conditional formatting by color and asterisks 1

Back
Top