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

B

BVB1200

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

John

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

Petros

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
Dropdown with signatures 1
Excel does not accept text format! 0
Line Numbers Will Not Show 0
How do I display a "+" in front on positive numbers 3
Possible to Combine reports to's to a single box? 0
display contents of preceeding cells consecutively 15
Sum over a variable number of cells 3

Top