pos & negative format??
 

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

pos & negative format??
 

One way...

Custom format:

+General;-General;0

--
Biff
Microsoft Excel MVP


"d fallon" wrote in message
...

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

pos & negative format??
 

Apply a custom format of

+0;-0;0
Mike

On Fri, 25 Sep 2009 11:04:01 -0700, d fallon
wrote:


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

pos & negative format??
 

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

Format - Cells... - Number | Custom
--
HTH...

Jim Thomlinson


"d fallon" wrote:


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

pos & negative format??
 

+0;-0;0

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

--
Biff
Microsoft Excel MVP


wrote in message
...
Apply a custom format of

+0;-0;0
Mike

On Fri, 25 Sep 2009 11:04:01 -0700, d fallon
wrote:


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

pos & negative format??
 

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

Jim Thomlinson


"T. Valko" wrote:

+0;-0;0

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

--
Biff
Microsoft Excel MVP


wrote in message
...
Apply a custom format of

+0;-0;0
Mike

On Fri, 25 Sep 2009 11:04:01 -0700, d fallon
wrote:


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