Show + beside positive number?

S

SammyJJones

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
 
S

SammyJJones

Thank you SteveG,

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


Thanks,
Sammy
 
S

SammyJJones

Perfeck Mike,

Thank you,

Sammy



Mike said:
Sammy -

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

- Mike
www.mikemiddleton.com

"SammyJJones" [email protected] 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?action=getinfo&userid=7571
View this thread:
http://www.excelforum.com/showthread.php?threadid=500596
Click to expand...
 
Top