Sign Function

  • Thread starter Thread starter Krissy
  • Start date Start date
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
 
Krissy,

Format|Cell|Number|Custom and use

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

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

PC
 
Back
Top