adding a '+' in front of a positive number

Hello all,

anyone know how to make a '+' sign show up in front of a positive
number?

also, if there is no 'clean' way to do it, how do you concatenate a
text string with an equation (i.e., something like '=A1+A12')

thanks,
Mike

Use a custom format like +0.00;-0.00;0.00

="Text string"&TEXT(A1+A12,"format")

so using the custom format

="Text string"&TEXT(A1+A12,"+0.00;-0.00;0.00")

--
Regards,

Peo Sjoblom

(No private emails please)


"mike" <[email protected]> wrote in message
news:[email protected]...
> Hello all,
>
> anyone know how to make a '+' sign show up in front of a positive
> number?
>
> also, if there is no 'clean' way to do it, how do you concatenate a
> text string with an equation (i.e., something like '=A1+A12')
>
> thanks,
> Mike
>