Forum Discussion
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 AmairahSilver 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.
- Anonymousthanks
- bhushan_zIron 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