adding a '+' in front of a positive number

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

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)
 
Back
Top