| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I would like a cell to show a + or - sign before number.
BUT ... I forgot the zero ! ! !
+#,###;-#,###;0 -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "RagDyeR" wrote in message ... +#,###;-#,###; The last semi-colon eliminates the + sign from 0's -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "BVB1200" wrote in message ... When showing numbers in a cell I would like positive numbers to be preceeded with a + sign. I would like negative numbers to be preceeded by a - sign. How can I format to do this automatically? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In excel how do I show a divide sign | Excel Discussion (Misc queries) | |||
| Reverse the sign of a number in a cell | Excel Worksheet Functions | |||
| Reverse the sign of a number in a cell | Excel Worksheet Functions | |||
| Show = sign | Excel Discussion (Misc queries) | |||
| How do I show a multiplication sign in front of a number | Excel Discussion (Misc queries) | |||
Threaded Mode
