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?

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?

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?

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?

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?

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?

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?