Ask Your Question

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

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.


  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


I can't upvote yet but this is brilliant! I wanted blank date cells so needed two semicolons. From 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

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


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

Seen: 46 times

Last updated: Aug 24