| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I would like a cell to show a + or - sign before number.
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I would like a cell to show a + or - sign before number.
+#,###;-#,###; 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I would like a cell to show a + or - sign before number.
Format cells as:
custom==+#,##0;-#,##0 HTH "BVB1200" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I would like a cell to show a + or - sign before number.
use a custom format +#,##0;-#,##0
-- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "BVB1200" wrote: 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I would like a cell to show a + or - sign before number.
One way:
Format/Cells/Number/Custom +General;-General;General;@ In article , BVB1200 wrote: 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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I would like a cell to show a + or - sign before number.
Hello. Right click/format cells/Number/Custom/+#,##0.00;[Red]-#,##0.00
I used one of the existing options and just added the + sign You can choose or create the one that fits you best "BVB1200" wrote: 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? |
|
#7
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? |
| Reply |
| 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) | |||
Linear Mode
