"numbers" zero value?

Discussion in 'Mac Apps and Mac App Store' started by m2uk, Oct 21, 2007.

  1. macrumors regular

    Joined:
    Jan 13, 2004
    Location:
    Finland
    #1
    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
     
  2. macrumors 68030

    Analog Kid

    Joined:
    Mar 4, 2003
    #2
    One way is to apply a conditional format and set the text color to be the same as the background color if the value equals zero...
     
  3. thread starter macrumors regular

    Joined:
    Jan 13, 2004
    Location:
    Finland
    #3
    Ah, that is perfect. Thanks :) Still getting used to moving things from Excel.

    It would be nice if Apple fixed the bug whereby numeric keyboards on European computers (who use comma as decimal place) work !

    Thanks again.
     

Share This Page