Back to Index

EXCEL 2010-2007 : DO NOT DISPLAY ZERO VALUES

I recopy a formula in a given form. It is done "in advance" because the formula will only display the result when the required data will be typed.
I get very ugly 0 !

form with zero values for an "empty" formula

Answer : there is no formula problem, therefore do not try to solve it with an IF function ... You have a viewing problem. You should order NOT TO DISPLAY ZERO VALUES

2010 : FILE - OPTIONS - ADVANCED Category - DISPLAY OPTIONS FOR THIS WORKSHEET Topic - SHOW A ZERO IN CELLS ... Option
2007 : same but FILE = OFFICE Button

Excel options with the required option

Valid only for this worksheet. Your "empty" formulas remain "empty" but work all right when the required data is typed in the form.

© Copyright : Office Doc / Web development by Office Doc