Hiding Zero Values

Yes, you can hide zeroes:

1) Select the cells you want to format.

2) Bring up Inspector and click on the Cells Inspector

3) For Format, choose "Custom..." from the popup menu

==> A sheet will drop down showing options for the Custom format

4) Click the round "+" button to add a condition

5) Choose "If 0" from the popup menu

6) Set the format to be blank (see image)

7) Click "OK"

1. You are responding to a threqad that is three years (and a few versions of Numbers) old
2. The steps you describe apply to Numbers for OSX, not iOS.

Thanks James. Sorry, I will check what context I'm in (iOS vs. Mac OS X) next time I reply to a thread.

Here's a workaround for iOS:

I don't see a way to create a custom format in Numbers for iOS, but if you create a spreadsheet on Mac OS with a custom format as I describe above and then sync (via iCloud) to an iPad, the custom format works on iOS and can be copied and pasted to various iOS spreadsheets. The custom format will retain the name that you gave it on Mac OS ("Custom Format 1" in the example I gave above), but it doesn't appear in the Format popover unless you select a cell or cells where that format has been pasted.

James, you're perfectly right, but I must admit I was very happy to find Wilmot's answer here, it helped me very much.

Thank you very much, Wilmot!

Thank you Wilmot!

This helped me too. 🙂