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!
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!
SUSIE
Thank you very much
zilliq
works perfectly thank you
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.
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.