Cell not formating

M

Mojoala

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
 
G

Gord Dibben

Tools>Options>View.

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
 
Top