Positive (+) Number....

[Shhhh]

Hello all...

If I type into my worksheet -120... it shows up as -120

However if I type +120... it shows up as 120.

How can I tell excel to show the plus sign in front of positive
numbers??


Thank you all!

 

[AltaEgo]

You need a custom format

XL2003
http://office.microsoft.com/en-us/excel/HP051995001033.aspx?pid=CH010036911033

XL2007
http://office.microsoft.com/en-us/excel/HP012165031033.aspx?pid=CH100870371033


Use the following as your custom format:

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

 

[DILipandey]

One way could be:-
=IF(A2>=0,"+"&A2,A2)
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India

 

[Shane Devenshire]

Hi,

Choose Format, Cells, Number tab, Custom and enter

"+"#,##0;-$#,##0;0

 

[Shane Devenshire]

Take the $ sign out

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