HI MOJOALA! I usually ask the questions, so I'm about to switch roles here.

On your main toolbar, click on Tools -- Options -- and check or Uncheck
the Zero Values radio box. That should do it.

"Mojoala" wrote:

I have recieved a spreadsheet.

the cells will not show a zero if the value is zero.
it shows a blank cell.
have tried different ways to format the cell to no avail.

it just will not accept a format