Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing zero values from a spreadsheet.
I have already gone to tools and options and hidden all zero values, but I
still have about six cells that have formulas in that are showing the zeros. Are there any other things that can be done to hide these few zeros that insist on hanging on? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing zero values from a spreadsheet.
Check the formulas..........might be replace the conditional 0 results with ""
For example, change this =IF(A1=B1,"yes",0) to this =IF(A1=B1,"yes","") hth Vaya con Dios, Chuck, CABGx3 "Red1014" wrote: I have already gone to tools and options and hidden all zero values, but I still have about six cells that have formulas in that are showing the zeros. Are there any other things that can be done to hide these few zeros that insist on hanging on? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing zero values from a spreadsheet.
Apologies if this appears twice, I posted it once and it didn't appear
Are the formulae creating small decimal values e.g. 0.23 and then being formatted to zero decimal places, switching off the display of zero values will not hide these as they are not strictly zero, just displayed as zero. blueju |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing zero values from a spreadsheet.
Red1014 wrote: I have already gone to tools and options and hidden all zero values, but I still have about six cells that have formulas in that are showing the zeros. Are there any other things that can be done to hide these few zeros that insist on hanging on? Are the results of the formulae generating decimals e.g. 0.23 and then being formatted to show no decimal places (this would appear in your sheet as a zero), excel will still show these values as they are not actually zero. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinking to Excel 2000 with a linked spreadsheet | Excel Discussion (Misc queries) | |||
Spreadsheet merging problems | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Look up values and place in spreadsheet | Excel Discussion (Misc queries) | |||
Removing Hard Borders from Excel Spreadsheet | Excel Worksheet Functions |