Forum Discussion
Adding text to formula
Trying to create a formula to do this for example: first cell just a number, say 100, second cell a number plus text, say 2 kg would like to multiply and show "200 kg" as a result. Think need an...
Numbers can be formatted with a custom number format to include text without affecting the data type.
Note in the following screenshot how the cell C1 hs only the formula
=A1*B1
and the cell shows the result as
6 kg
This is achieved with the custom format
0 k\g
Some characters have special meaning in number formats an need to be preceded by a \ sign in order to show in a number format.
The advantage of formatting a cell is that its underlying data type is still a number and can be used in further calculations. If you append text, as suggested with =A1*B1&" kg", the result is text and cannot easily be used in further calculations.
You are right Ingeborg , the result will be text in my suggestion.
if the user need to do more calculation on the result he should use the way you mentioned.
if the user need to do more calculation on the result he should use the way you mentioned.