I would like a cell to show a + or - sign before number.

G

Guest

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?
 
R

RagDyeR

+#,###;-#,###;

The last semi-colon eliminates the + sign from 0's
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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?
 
G

Guest

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)
 
G

Guest

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
 
R

RagDyeR

BUT ... I forgot the zero ! ! !

+#,###;-#,###;0


--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------


+#,###;-#,###;

The last semi-colon eliminates the + sign from 0's
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display plus sign for positive numbers 2
How do I display a "+" in front on positive numbers 3
show plus sign in grid 3
Negative Numbers 8
Displaying negatives with (brackets) 3
Number formatting 1
Coloring cells 8
Excel 2007 - display negative numbers with minus sign and parenthe 3

Top