Forum Discussion
Solved
global formula for entire worksheet? override any cell that has "0" replace with blank value
I have a comprehensive summary worksheet that pulls various cell data from another worksheet. However, if the referencing worksheet has a null value, excel will pull it forward as a zero (0) value upon display. Rather than have a relative formula to each cell, is there a way to override any field (one time, globally) containing zero and replace it with a true blank/null value?
- Disregard, I found a workaround noted here
https://support.microsoft.com/en-us/office/display-or-hide-zero-values-3ec7a433-46b8-4516-8085-a00e9e476b03#:~:text=Under%20Display%20options%20for%20this,have%20zero%20value%20check%20box.
1 Reply
- Disregard, I found a workaround noted here
https://support.microsoft.com/en-us/office/display-or-hide-zero-values-3ec7a433-46b8-4516-8085-a00e9e476b03#:~:text=Under%20Display%20options%20for%20this,have%20zero%20value%20check%20box.