Excel 2013 allows user to display blank value instead of zero value for any expression. This is useful when you want the result value for any formula to be left blank instead of displaying zero.
Step 1: Click File menu, select Options from the menu list.
Step 2: In the Options window, click the Advanced tab.
Step 3: Scroll down the Advanced tab until you see the Display options for this worksheet.
Step 4: Un mark the check box with caption as “Show a zero in cell that have zero value”.
Step 5: Click OK button in the Options screen to confirm and save the changes.