Cell not formating

  • Thread starter Thread starter Mojoala
  • Start date Start date
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
 
HI MOJOALA! I usually ask the questions, so I'm about to switch roles here.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question about conditional formatting of zeros in Excel 0
Formatting 0 values to show blank cells 4
Custom Number Format for text 8
Quote Marks Question 2
zeros show as dashes in spreadsheet, want to show 0. 2
Difference of empty cell and zero value when formatting 4
Need help 5
Conditional formatting in Excel 2010 2

Back
Top