Cell not formating
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.
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 |
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 |
All times are GMT +1. The time now is 08:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com