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."
 
Back
Top