-ve no with -1; positive with sign+ and 0 no sign? Tks.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shirley - 23 Nov 2005 06:07 GMT

How do I show -ve numbers with minus sign; +ve numbers with plus sign and 0
without any sign on Excel?

Reply to this Message

Rowan Drummond - 23 Nov 2005 06:14 GMT

Select the cells you want to apply this to. From the menus select
Format>Cells. Select the Number tab and then in the Category box Select
Custom. In the Type box enter:
+#,##0;-#,##0;0
Click on OK

Hope this helps
Rowan

> How do I show -ve numbers with minus sign; +ve numbers with plus sign and 0
> without any sign on Excel?

Reply to this Message