| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
| does cell formating move with sorting | Excel Discussion (Misc queries) | |||
| Formating cell to 1000 | Charts and Charting in Excel | |||
| color formating ontingenton upon another cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
