m2 after a sum equation

[Johnny_Naughts]

Please can u assist. I require a "m2" to appear after my equation total in the same cell. Is this possible

 

[Aladin Akyurek]

On 2002-04-10 04:36, Johnny_Naughts wrote:
Please can u assist. I require a "m2" to appear after my equation total in the same cell. Is this possible

Change your formula to:

=your-formula&" m2"

 

[paludgnp]

Yes, it is possible, but your cell will become text and therefore can't be summed (e.g.) later with another one without removing the m2)

If in Cell(1,2) you want to have the result of Cell (1,1) + m2, write the code as follows:
=C1 & " m2"
The '&' concatenate one string with another. Your first string is determined by the result of C1 and second is enabled by the ' " ' text operator.
good luck