pos & negative format??

[d fallon]

How can I show a number format that is positive with a "+" sign in front of
the number?

If the number is positive 15 I want to see +15, or if negative 23 a -23...
(the negiative is no problem I know).

thanks

 

[T. Valko]

One way...

Custom format:

+General;-General;0

 

[me]

Apply a custom format of

+0;-0;0
Mike

 

[Jim Thomlinson]

Use a custom format like this.
+0; -0; 0

Format -> Cells... -> Number | Custom

 

[T. Valko]

+0;-0;0

Try that format and then enter this in the cell: 0.01

 

[Jim Thomlinson]

Good point. The OP was showing integers which is the direction I went but
yours is the better answer.