Welcome to iPadForums.net Guest - Click Here to Register

IPad Numbers - Hiding zero value

This is a discussion on IPad Numbers - Hiding zero value within the iWork Forum forums, part of the iPad App Store category; 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 ...

iPadForums.net is the original Apple iPad Forum! Registered Users do not see these ads. Please Register - It's Free!
+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    iPF Noob
    Member #
    206986
    Join Date
    May 2012
    Location
    North Yorkshire
    Posts
    1

    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

  2. Ads


  3. #2
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,432
    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.

    IPad Numbers - Hiding zero value-blankforzero.jpg


Home | Forum | Active Topics | What's New

Links

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Similar Threads

  1. Replies: 1
    Last Post: 02-15-2012, 09:40 PM
  2. Hiding apps on iPad 1
    By deekayoz in forum iPad 1 Forum
    Replies: 3
    Last Post: 12-28-2011, 04:27 AM
  3. Hiding cells in numbers
    By skeeter111 in forum iPad General Discussions
    Replies: 3
    Last Post: 12-07-2011, 08:17 AM
  4. Un-hiding Apps
    By jackcf in forum iPad 2 Forum
    Replies: 4
    Last Post: 12-04-2011, 07:33 AM
  5. Hiding a/or column(s) in Numbers.
    By marviwork in forum iPad Apps
    Replies: 1
    Last Post: 05-17-2011, 11:05 PM

Search tags for this page

blank zero numbers apple
,
conditional format
,

hide zero values in numbers

,

hide zeros in numbers

,

ipad numbers hide zero row

,

is null in ipad numbers

,

iwork numbers hide zero values

,
iwork numbers hide zeros
Click on a term to search for related topics.

Tags for this Thread