ExcelBanter - How to display "+" sign

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to display "+" sign (https://www.excelbanter.com/excel-discussion-misc-queries/103463-how-display-sign.html)

Lamb Chop

How to display "+" sign

How can I change the format of the cell so that when it is positive, it
shows "+"

e.g.

15 --- +15
-3 ----- -3

Thanks

Biff

How to display "+" sign

Use a custom format like:

"+"0;-0;0

Biff

"Lamb Chop" wrote in message
...
How can I change the format of the cell so that when it is positive, it
shows "+"

e.g.

15 --- +15
-3 ----- -3

Thanks

All times are GMT +1. The time now is 07:34 PM.