Software

Ask something
Discussion Locked

Zeros as formula results

0 helpful
5 replies

by johnakin

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a way I can have a cell show as blank until a value other than zero is the result of a formula?

5 replies

by peyison

With your workbook open, select Tools -> Options and from the View tab, uncheck Zero Values.

Hope this helps.

by dklippert

Using Tools>Options is a good way.
Some others are:
Format the cell something like #;-#;
Use an if statement =IF(A1-A2=0,"",A1-A2)
There are no spaces between the quotes.

This discussion is closed to new replies.