ExcelBanter - Asterisks in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Asterisks in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/31336-asterisks-excel.html)

Walsh jj

Asterisks in Excel

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.
--
Walsh jj

Jay

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.

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

All times are GMT +1. The time now is 02:47 AM.