Sign Function

K

Krissy

If I am in Excel and am wanting to show a + sign before
every number, how can that be done automatically? This is
very easy to do with a negative number, I just need it to
show the actual plus sign though.

Thank you
 
P

Paul Corrado

Krissy,

Format|Cell|Number|Custom and use

+#,##0;-#,##0

to show positive #'s with a "+" and negatives with a "-"

PC
 
Top