Show + beside positive number?
 

A1 = 5
B1 = 6
C1 = A1-B1

C1 Displays: -1


A1 = 6
B1 = 5
C1 = A1-B1

C1 Displays: 1

Is there any way to make C1 display "+1" rather than just "1".


Thanks in advance,
Sammy

Show + beside positive number?
 

Sammy,

Custom format your cells like this.


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

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=500596

Thank you SteveG,

1 problem however.... with this it shows "0" as "+0"..... any fix?


Thanks,
Sammy

Show + beside positive number?
 

Sammy -

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

- Mike
www.mikemiddleton.com

"SammyJJones" wrote in message
...

Thank you SteveG,

1 problem however.... with this it shows "0" as "+0"..... any fix?


Thanks,
Sammy


SteveG Wrote:
Sammy,

Custom format your cells like this.


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

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=500596


--
SammyJJones

Show + beside positive number?
 

Thanks Mike.


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=500596

Perfeck Mike,

Thank you,

Sammy