Sign Function

[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

 

[Bob Phillips]

Krissy,

Set a custom format, such as

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

 

[Paul Corrado]

Krissy,

Format|Cell|Number|Custom and use

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

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

PC