IPad Numbers - Hiding zero value

Hi just wondering if anyone can tell me how to hide zero values in cells to tidy up my spreadsheets as I'm creating new invoices for work and want them to look as good as possible.

Thanks

For entry fields all you can do is select the cells and choose Delete. Unfortunately that also resets the cell to the default format; which may or may not matter to you. You can then select the blank cell, format it, and copy (or fill) it back to the now blank cells without the zero reappearing (usually).

If you are worried about messing up the spread sheet, do your tweaking on copy when you are preparing to print.

For equations, you can imbed your formula in an IF statement that tests to see if the result is non-zero, then use the else portion to esle (is zero) part of the statement to enter a null text string (use the abc button). This is weird looking, since you have to enter the function twice. Once as the condition and second as the equation.

Attachment 16460