Excel Formatting Question

Factual Questions
1

Every week I get a spreadsheet forwarded to me second hand so I don’t have any direct contact with the author.

The input cells are formatted so that ZERO’s do not show up. For my purpose, I like the ZERO’s to show up and I cannot figure out how to unformat the cells. And it the format is for all cells in the sheet, even if input “0” in the non-input cells.

The number format was “General”. Negative numbers show up.

I have selected the cells and cleared Formats. I have checked Conditional Formatting. Nothing strange

I have found a couple of “work-arounds”, I enter 0.00001 and format it to no decimals and I can also copy the entire sheet to a brand new sheet and it works for my purposes.

But I am curious to know what the author has done to this spreadsheet to make ZERO’s unseen.

2

File >> Options >> Advanced >> Display options for this worksheet: >> Show a zero in cells that have zero value

3

Thank. I am using Excel 2007 so I had no “File” command.

But I found it in Excel Options, Advanced (Scroll down to Display Options for this Worksheet)

Lots of good stuff in Excel Options. I looked here but I didn’t scroll down on the Advanced subsection.

Still not sure why the author wanted to hide ZEROs.

Again Thank you very much.

4

You might get traditional File, Edit, etc. menus if you hit the Alt key on your keyboard.

Don’t know why Microsoft and others are so determined to get rid of predictable pull-down menus in favor of ribbons and buttons.