? How to make Numbers format with + or - sign

[Tumbleweed666]

I want to format some cells, so that if the value is positive, it displays with a plus in front, otherwise it displays with a minus (unless its zero as it does now

So cells that contain say positive 20 or 30, show as +20, +30

Google searches lead me to believe this cant be done, can anyone show me wrong please?

TIA

 

[Tumbleweed666]

I want to format some cells, so that if the value is positive, it displays with a plus in front, otherwise it displays with a minus (unless its zero as it does now

So cells that contain say positive 20 or 30, show as +20, +30

Google searches lead me to believe this cant be done, can anyone show me wrong please?

TIA

Doh proved myself wrong https://discussions.apple.com/message/10281095#10281095

 

[Carlanga]

which is why you do a search on google first then make a thread

 

[Tumbleweed666]

I did both.

Googled, didnt find anything, posted, googled more, found something.

Its like when you ask your wife "where the hell are my car keys I've been looking for 10 minutes" and she says "right in front of you"