Display or Hide Zero Values in Excel

Annoying issue where when I changed the formatting to Scientific, all the blank cells became 00E00. I didn't want that crowding my spreadsheet.

Solution:

• File > Options > Advanced 
• Under Display options for this worksheet, select a worksheet, and then do one of the following:
• To display zero (0) values in cells, check the Show a zero in cells that have zero value check box.
• To display zero (0) values as blank cells, uncheck the Show a zero in cells that have zero value check box.

Source