not able to type number and text in same cell?

[Deleted]

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

[#2 · Accepted solution]

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.

[#3]

thanks

[#4]

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

[#5]

@bhushan_z  much better resolution.