Excel format question

Occasionally I get a file whose account buckets appear to be blank. I format the cells as Numeric (two decimals, no commas), and then change all blanks to zeroes. It usually gives the desired result of zero-amounts being displayed as ‘0.00’. But sometimes there is no apparent change. Clicking on a cell reveals that there is a zero in it. That’s fine, but I want to see 0.00 in the cell. I solve this by copying the entire file and using Paste Special (as) Values into a new workbook. No biggie, but it’s annoying.

How do I tell Excel to display zeroes instead of nothing in numeric cells that only contain ‘0’?

From Microsoft: Microsoft Support

  1. On the Tools menu, click Options, and then click the View tab.
  2. Do one of the following:
    * To display zero (0) values in cells, select the Zero values check box.
    * To display zero values as blank cells, clear the check box.

That worked.