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