IPad Numbers - Hiding zero value

Discussion in 'iWork Forum' started by Elinrichbrad, May 20, 2012.

  1. Elinrichbrad
    Offline

    Elinrichbrad iPF Noob

    Joined:
    May 20, 2012
    Messages:
    1
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    North Yorkshire
    Ratings:
    +0 / 0
    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
  2. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,870
    Thanks Received:
    2,244
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,683 / 1
    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.

    blankForZero.jpg

Share This Page

Search tags for this page
apple numbers show zero
,
apple numbers show zero as
,
can not hide column in ipad numbers
,
dont show zero values in numbers
,
hide a row in iwork numbers if a value is 0
,
hide zero in numbers ipad
,

hide zero values in numbers

,

hide zeros in numbers ipad

,
how to hide 0 in cell in numbers
,
how to suppress zero in iwork numbers
,
if not zero apple numbers
,
in iwork numbers if value is 0 how can it be blank
,
ipad passcode zero value
,
ipad zeros in cells
,

iwork numbers hide zero values

,
numbers 09 hide zero
,
numbers ios hide zero value cells
,
numbers spreadsheet hide zero values
,

passcode fields zero values on iphone

,
replace zero iworks numbers