Is there any way to say if a cell's value is zero, then do not display the zero ? I want to make a spreadsheet look a lot tidier but all the unused calculation values show zeros and I'd rather they displayed a blank.
Sorry if this sounds complex. I cannot think how to simplify this and have tried searching on apple's support for this
Thanks
Sorry if this sounds complex. I cannot think how to simplify this and have tried searching on apple's support for this
Thanks