| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format negative figs | Excel Discussion (Misc queries) | |||
| Negative Time Format | Excel Discussion (Misc queries) | |||
| Format to a negative value | Excel Worksheet Functions | |||
| Time in a negative format? | Excel Discussion (Misc queries) | |||
| Negative Number Format () Not available | Excel Discussion (Misc queries) | |||
![d fallon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
