Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom format num 0 with a "+"
How does one custom format numbers 0 to appear with a preceding "+" (plus
sign) ? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom format num 0 with a "+"
+ General;General
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Max" wrote in message ... How does one custom format numbers 0 to appear with a preceding "+" (plus sign) ? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom format num 0 with a "+"
Thanks Bob. Need a variation ..
Let's say I have 3 numbers below, currently formatted as: #,##0 (Number format, with thousand separator, to zero dp) -25,988 21,951 0 I would like to adjust the custom format so that it appears as: -25,988 +21,951 0 (only numbers 0 to have the plus sign. zeros and negative numbers remain as-is) Thanks "Bob Phillips" wrote in message ... + General;General |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom format num 0 with a "+"
+#,##0; -#,##0; 0
-- David Biddulph "Max" wrote in message ... Thanks Bob. Need a variation .. Let's say I have 3 numbers below, currently formatted as: #,##0 (Number format, with thousand separator, to zero dp) -25,988 21,951 0 I would like to adjust the custom format so that it appears as: -25,988 +21,951 0 (only numbers 0 to have the plus sign. zeros and negative numbers remain as-is) Thanks "Bob Phillips" wrote in message ... + General;General |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom format num 0 with a "+"
Thanks, David. That worked well, and I can see the pattern.
"David Biddulph" <groups [at] biddulph.org.uk wrote in message ... +#,##0; -#,##0; 0 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Format font for "xx" to yellow | Excel Discussion (Misc queries) | |||
Custom Format xx="" | Excel Discussion (Misc queries) | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
How do I get rid of "Top 10" and "Custom" choices Autofilter? | Excel Worksheet Functions | |||
custom format cell, if value is 0, then write "-" | Excel Discussion (Misc queries) |