ToolsOptionsView.

Is "Zero Values" checked?

Are there formulas in the cells which return a blank if value is zero?

i.e. =IF(A1*A2=0,"",A1*A2)


Gord Dibben Excel MVP

On Mon, 17 Jan 2005 13:29:22 -0600, "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