| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I default blank cells to "0"?
In an Excel spreadsheet I have created a formula which includes blank cells,
which gives me an error. If I change the blank cells to "0" than the formula is accepted. The spreadsheet is large and would be very time consuming to go through and add a zero to each blank cell. Is there a way to change the cells automatically? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
| How to set the default "summarized by" of a data field to "Sum"? | Excel Discussion (Misc queries) | |||
| How to fill in "BLANK" Cells Automactically...Large Spread Sheet | Excel Discussion (Misc queries) | |||
| Protect shouldn't default to "allow users to select locked cells" | Setting up and Configuration of Excel | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Threaded Mode
