Forum Discussion

Anonymous's avatar
Anonymous
Dec 10, 2017
Solved

not able to type number and text in same cell?

Hi experts

while typing a number with a unit inside the cell, im getting an error massage, any idea what am i missing here?

 

Yossi

while typing a number with a unit inside the cell, im getting an error massage

  • Yossi,

     

    Replace this:

     

    =-117 dbm

     

    With this:

     

    =-117&" dbm"

     

    Any text string in a formula should enclose it with quotation marks like this: "dbm"

    If you want to combine a number and text you should use this operator: & between them.

     

4 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor

    Yossi,

     

    Replace this:

     

    =-117 dbm

     

    With this:

     

    =-117&" dbm"

     

    Any text string in a formula should enclose it with quotation marks like this: "dbm"

    If you want to combine a number and text you should use this operator: & between them.

     

      • bhushan_z's avatar
        bhushan_z
        Iron Contributor

        Avoid mixing number (-117) with text (dbm)

        Best way is to correct the cell formatting.

        for that:

        1) right click on cell

        2) Format Cells

        3) Use Custom format as below screenshot and you are done

        now every time u update the value, Excel automatically adds 'dbm' at the end

         

Resources