Ask Your Question

How to display numbers only if it's positive in Calc [closed]

asked 2013-07-15 03:48:00 +0200

Jihui Choi gravatar image

Hello. all

I want to numbers only if it's positive in Calc. But I couldn't find any postion or cell format. In Excel, I used 0_); as cell format, however this doesn't work in calc.

How can I do this in Calc?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-03 23:19:59.282076



Answer : The format for numbers consists of "positive;null;negative, so for me, **General;;** from this (</p<>>)

Jihui Choi gravatar imageJihui Choi ( 2013-07-15 03:53:57 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-07-15 04:44:57 +0200

ROSt52 gravatar image

you might be able to use conditional formatting:

  • Select the area in which you have your numbers

  • click format / conditional formatting / condition

  • set condition to "less than" and "0"

-click on Applied Style which appears as "Default" and select "new style"

  • select in the style window a font color which matches your back ground color (I used white and call the new style (WhiteFont)

  • click OK and all numbers <0 will not be seen.

I recommend to read also in help file and help wiki.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-07-15 03:48:00 +0200

Seen: 3,062 times

Last updated: Jul 15 '13