Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting rid of '0' in a cell
When referencing an empty cell, like in 'Sheet A'!B3:B6 from Sheet B, instead
of displaying an empty cell as well, I get a 0 in it. How do I get rid of this strange behaviour? Note: the cell format is General, switching to Text did not help ... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting rid of '0' in a cell
If you are linking directly to another cell, eg A1 in Sheet1, you
could do this: =IF(Sheet1!A1="","",Sheet1!A1) Another method is to use Conditional Formatting on the destination cell(s), such that a white foreground colour is used if the cell evaluates to 0, thus making the cell appear blank (on a white background). Hope this helps. Pete On Sep 29, 1:18*pm, Mac wrote: When referencing an empty cell, like in 'Sheet A'!B3:B6 from Sheet B, instead of displaying an empty cell as well, I get a 0 in it. How do I get rid of this strange behaviour? Note: the cell format is General, switching to Text did not help ... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting rid of '0' in a cell
Great! I'll use the former method, seems more 'transparent' to me. Thank you!
"Pete_UK" wrote: If you are linking directly to another cell, eg A1 in Sheet1, you could do this: =IF(Sheet1!A1="","",Sheet1!A1) Another method is to use Conditional Formatting on the destination cell(s), such that a white foreground colour is used if the cell evaluates to 0, thus making the cell appear blank (on a white background). Hope this helps. Pete On Sep 29, 1:18 pm, Mac wrote: When referencing an empty cell, like in 'Sheet A'!B3:B6 from Sheet B, instead of displaying an empty cell as well, I get a 0 in it. How do I get rid of this strange behaviour? Note: the cell format is General, switching to Text did not help ... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting rid of '0' in a cell
You're welcome.
The drawback with the first method is that you need to amend all your formulae, whereas the second method just acts on the result of those formulae. Pete On Sep 29, 2:07*pm, Mac wrote: Great! I'll use the former method, seems more 'transparent' to me. Thank you! "Pete_UK" wrote: If you are linking directly to another cell, eg A1 in Sheet1, you could do this: =IF(Sheet1!A1="","",Sheet1!A1) Another method is to use Conditional Formatting on the destination cell(s), such that a white foreground colour is used if the cell evaluates to 0, thus making the cell appear blank (on a white background). Hope this helps. Pete On Sep 29, 1:18 pm, Mac wrote: When referencing an empty cell, like in 'Sheet A'!B3:B6 from Sheet B, instead of displaying an empty cell as well, I get a 0 in it. How do I get rid of this strange behaviour? Note: the cell format is General, switching to Text did not help ...- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) |