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