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" <mike_newsgroups@yahoo.com> wrote in message
news:1118095994.793200.166360@o13g2000cwo.googlegroups.com...
> 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
>