How to remove zeros in Excel
Solved
SUSIE
-
zilliq -
zilliq -
Hello,
I have several very simple Excel tables. In fact, I have 4 Excel files that make a fifth file "RECAP". That is to say: one file with several tabs named after my children (the first file is called SIMON), and then 3 other files identical to the one for SIMON, named after my other 3 children. I created a RECAP file that includes only one tab from the 4 files named after my children. On this file, where there are only links, some cells show 0 when there is nothing in the source file. My question is: how can I remove these 0s using a formula? I imagine my explanations are not very clear, but if someone could help, I can send my files via cjoint.com. Thank you in advance.
I have several very simple Excel tables. In fact, I have 4 Excel files that make a fifth file "RECAP". That is to say: one file with several tabs named after my children (the first file is called SIMON), and then 3 other files identical to the one for SIMON, named after my other 3 children. I created a RECAP file that includes only one tab from the 4 files named after my children. On this file, where there are only links, some cells show 0 when there is nothing in the source file. My question is: how can I remove these 0s using a formula? I imagine my explanations are not very clear, but if someone could help, I can send my files via cjoint.com. Thank you in advance.
3 answers
-
In the 'menu' versions of Excel, it seems to me that in tools-options-display, it was possible to choose not to display zero values.
In the new versions, I struggled to find it, but I found it by clicking on the small arrow at the top (customize the quick access toolbar), other commands, advanced options, show options for this worksheet, show a zero in cells that have a null value...
--
Stop failing the Turing test! -
Hi,
So several possibilities
it is possible to activate the function to not display values of 0 which may be annoying in certain cases where you want to display a result = to zero
then it is possible to put a conditional in your formula like =if(your formula=0,"",your formula)
or even write a custom format so that the 0 values are colored like the inside of your cell (white if your cell has no color)
--
See you later
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge. -
