Results 1 to 4 of 4

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

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

  1. #1
    New Member
    Join Date
    Sep 2011
    Posts
    10

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

    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

  2. #2
    Board Regular
    The ONLY cool kid on the block
    BenMiller's Avatar
    Join Date
    Nov 2011
    Location
    Jerusalem
    Posts
    1,890

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

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

  3. #3
    Board Regular
    Join Date
    Oct 2011
    Posts
    82

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

    Or even;

    =yourformula&"*"

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

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    WA state
    Posts
    359

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

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

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

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com