How to add * symbol as text at end of cell with a formula?

[zdc88]

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

 

[BenMiller]

Type =CONCATENATE((yourformula),"*")

 

[DavyJones]

Or even;

=yourformula&"*"

Bear in mind that either option will convert the value to text!

 

[Scott R]

To maintain formatting of values, use =TEXT([number or formula],"#,##0")&"*".

Or you could create a custom number format of #,##0"*" or similar.