| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Blank cells instead of zero
Hi All,
I have a sheet where I load values based on selections from dropdown boxes. I also have the option of Drilling down on cells which will display children below the parent cells. When I do a drill down, the cells that do not have a numeric value change to zero and immediately update to be blank cells. I want them to be displayed as zeros. How can i do that? The format of these cells is 'custom' format!!! Thanks, Haarish. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
| How to count blank cells (Rows) between Non-Blank cells in Col "A" | Excel Discussion (Misc queries) | |||
| Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
| HELP: Last row of the column containing blank cells between non-blank cells | Excel Worksheet Functions | |||
| Making Blank Cells Really Blank (Zen Koan) | Excel Worksheet Functions | |||
Threaded Mode
