Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
keeping a cell blank
how can i make a cell stay blank when the value is 0. especially when i have
a formula in that cell. for instance it may set to sum a range however that range equals zero or some other formula that equals zero. I would like the cell to stay blank. this is for a cover page report that pulls alot of data from the enire workbook and i dont want it to be filled with a bunch of Zero's thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
keeping a cell blank
Option 1: =IF(your_formula=0,"",your_formula)
Option 2: Format/ Conditional Formatting/ Cell Value Is/ equal to : 0/ Format font colour to white (or whatever your cell background colour is) Option 3: Tools/ Options/ View/ deselect "Zero values" -- David Biddulph "James" wrote in message ... how can i make a cell stay blank when the value is 0. especially when i have a formula in that cell. for instance it may set to sum a range however that range equals zero or some other formula that equals zero. I would like the cell to stay blank. this is for a cover page report that pulls alot of data from the enire workbook and i dont want it to be filled with a bunch of Zero's thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
keeping a cell blank
Click TOOLS/OPTIONS and on the VIEW tab, locate the checkbox at bottom center
named ZERO VALUES and remove the checkmark. Hope this helps... -- Kevin Backmann "James" wrote: how can i make a cell stay blank when the value is 0. especially when i have a formula in that cell. for instance it may set to sum a range however that range equals zero or some other formula that equals zero. I would like the cell to stay blank. this is for a cover page report that pulls alot of data from the enire workbook and i dont want it to be filled with a bunch of Zero's thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
keeping a cell blank
hi
you could use an if formula in place of your other formula. =if(sum(range=0),"",sum(range)) the formula would still be in the cell but the cell would display a blank. regards FSt1 "James" wrote: how can i make a cell stay blank when the value is 0. especially when i have a formula in that cell. for instance it may set to sum a range however that range equals zero or some other formula that equals zero. I would like the cell to stay blank. this is for a cover page report that pulls alot of data from the enire workbook and i dont want it to be filled with a bunch of Zero's thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
keeping a cell blank
Kevin B comes to the resue again.... Thanks
"Kevin B" wrote: Click TOOLS/OPTIONS and on the VIEW tab, locate the checkbox at bottom center named ZERO VALUES and remove the checkmark. Hope this helps... -- Kevin Backmann "James" wrote: how can i make a cell stay blank when the value is 0. especially when i have a formula in that cell. for instance it may set to sum a range however that range equals zero or some other formula that equals zero. I would like the cell to stay blank. this is for a cover page report that pulls alot of data from the enire workbook and i dont want it to be filled with a bunch of Zero's thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
how to merge many cell to one cell with keeping all data | Excel Worksheet Functions | |||
Keeping a cell reference. | Excel Discussion (Misc queries) | |||
Keeping the cell blank... | New Users to Excel | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) |