Force "+" sign

[plh]

I was wondering if there was a way to create a number format that displays the
plus sign on positive numbers (and the minus sign on negative numbers).
Thanx,
-plh

 

[Niek Otten]

Format>Cells>Number tab, Custom, in the Type box, enter something like

+0;-0;0
Or
+#.00;-#.00;0

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I was wondering if there was a way to create a number format that displays the
| plus sign on positive numbers (and the minus sign on negative numbers).
| Thanx,
| -plh
|
|
| --
| I keep hitting "Esc" -- but I'm still here!

 

[oldchippy]

I was wondering if there was a way to create a number format tha
displays the
plus sign on positive numbers (and the minus sign on negativ
numbers).
Thanx,
-plh

Hi plh,

Try Custom format "+0;-0" without the ""

oldchippy :