| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display "+" when appropriate
Hi folks
Hopefully a simple one.. How do I force excel to display a plus (+) sign when the result of a calculation is positive (i.e. +3.6 rather than 3.6). The minius sign is, of course, displayed by default when the result is negative. Probably a cell custom format setting, but can't seem to find the right one. Unlike just adding a fixed symbol (e.g "%"), the + sign is conditional on the result .. and "+" is not a format.. Many thanks, Phil |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display "+" when appropriate
Hi
Try using a custom cell format like: +0.00;-0.00;0 Andy. "Phil C" wrote in message ... Hi folks Hopefully a simple one.. How do I force excel to display a plus (+) sign when the result of a calculation is positive (i.e. +3.6 rather than 3.6). The minius sign is, of course, displayed by default when the result is negative. Probably a cell custom format setting, but can't seem to find the right one. Unlike just adding a fixed symbol (e.g "%"), the + sign is conditional on the result .. and "+" is not a format.. Many thanks, Phil |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display "+" when appropriate
Andy
Briiliant! Many thanks for the prompt reply. Phil <Andy wrote in message ... Hi Try using a custom cell format like: +0.00;-0.00;0 Andy. "Phil C" wrote in message ... Hi folks Hopefully a simple one.. How do I force excel to display a plus (+) sign when the result of a calculation is positive (i.e. +3.6 rather than 3.6). The minius sign is, of course, displayed by default when the result is negative. Probably a cell custom format setting, but can't seem to find the right one. Unlike just adding a fixed symbol (e.g "%"), the + sign is conditional on the result .. and "+" is not a format.. Many thanks, Phil |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display "+" when appropriate
Pleasure! And thanks for the feedback.
Andy. "Phil C" wrote in message ... Andy Briiliant! Many thanks for the prompt reply. Phil <Andy wrote in message ... Hi Try using a custom cell format like: +0.00;-0.00;0 Andy. "Phil C" wrote in message ... Hi folks Hopefully a simple one.. How do I force excel to display a plus (+) sign when the result of a calculation is positive (i.e. +3.6 rather than 3.6). The minius sign is, of course, displayed by default when the result is negative. Probably a cell custom format setting, but can't seem to find the right one. Unlike just adding a fixed symbol (e.g "%"), the + sign is conditional on the result .. and "+" is not a format.. Many thanks, Phil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Report that display percentage below certain level | Excel Discussion (Misc queries) | |||
| Look Up and Display set data | Excel Discussion (Misc queries) | |||
| How do you display Greek and Russian languages in excel? | Excel Discussion (Misc queries) | |||
| Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Linear Mode
