Ask Your Question
1

How to hide zero values?

asked 2019-08-24 02:15:19 +0200

impatient gravatar image

I don't want zero values displayed

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2019-08-24 11:14:35 +0200

lazarus477 gravatar image

updated 2019-08-24 22:14:19 +0200

If you only wish to hide zero values in specific cases then set a custom number format that ends with a semicolon. You can start by setting one of the standard number formats and then append a semicolon to the end of the definition of that format.

Example:

  1. Select one or more cells.
  2. Right click the selection and choose Format Cells.
  3. In the input field labeled Format code, append a semicolon ";".

The answer from @robleyd is also accurate but removes zero values globally, as in all spreadsheets. There are times when it is desirable to display zero values, which is why I provide this answer.

edit flag offensive delete link more

Comments

I can't upvote yet but this is brilliant! I wanted blank date cells so needed two semicolons. From https://help.libreoffice.org/Common/N... In a number format code with three sections, the first section applies to positive values, the second section to negative values, and the third section to the value zero.

paulzag gravatar imagepaulzag ( 2019-10-10 00:27:38 +0200 )edit
1

answered 2019-08-24 04:40:20 +0200

robleyd gravatar image

Tools - Options - LibreOffice Calc - View; under Display uncheck Zero values; see if this works for you. Note that this is a global setting; it will apply to all spreadsheets.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. That will help other people with the same question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-08-24 02:15:19 +0200

Seen: 46 times

Last updated: Aug 24