Change your formula to: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
=your-formula&" m2"
Please can u assist. I require a "m2" to appear after my equation total in the same cell. Is this possible
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
Like this thread? Share it with others