This is a discussion on How to add * symbol as text at end of cell with a formula? within the Excel Questions forums, part of the Question Forums category; I am trying to add a * at the end of a value in a cell, used to signify a ...
I am trying to add a * at the end of a value in a cell, used to signify a note at the bottom of the page. However, as the cell contains a formula, excel thinks I am adding a multiplication sign instead.
Is there anyway to place a * at the end of the value, to show up in the cell as text? I would prefer not to have to paste the value of the cell and then add the *...
Appreciate any help, thanks
Bear in mind that either option will convert the value to text!
To maintain formatting of values, use =TEXT([number or formula],"#,##0")&"*".
Or you could create a custom number format of #,##0"*" or similar.