MacMost Now 629: iWork Numbers Cell Formatting

There are many options for formatting cells in iWork Numbers. You can choose the number of decimal places, or use fractions. You can format as currency or choose a different base system. You can choose from a variety of date and time formats. You can also create steppers, sliders and pop-up menus to make it easy to change values to cells. Conditional formatting allows you to have cells that change color and style with certain values or ranges.

Comments: 33 Responses to “MacMost Now 629: iWork Numbers Cell Formatting”

    Terry Riegel
    7 years ago

    I am trying to use conditional formatting based on a checkbox found in another cell. Any Idea how to do this?

      7 years ago

      I don’t think you can. It only works with the data in that cell.

    George Davies
    7 years ago

    Do you have a custom format to store valid email addresses?

    Jeff
    7 years ago

    =if(k7=””,””,K7/L7*60) where K7 =distance and L7= speed this formula returns a time format minutes and tenths of minutes. I need it to return the result in hours, minutes, seconds then the column that returns this result needs to be added up with other time results and come up with a total in hours, minutes,seconds. As in excel is there a way to create a macro to clear all user inputs so the spreadsheet can be re-used with all formulas remaining

    Char
    7 years ago

    New to Mac. I’ve always used Excel. Trying to format a cell in Numbers to enter blood pressure readings: i.e.: in a format that lets me enter as follows: 120/70
    I see the format selections. But so far none have let me use the above format.
    Help!

      7 years ago

      What was the name of the format you used in Excel to do this?

    Rick King
    7 years ago

    How do I get the Pop-up Menu cell format to propagate to a new row below without having to format the cell each time I add a row? Trying to format the whole column doesn’t work.

      7 years ago

      Not sure how you are trying to do this, but it works for me. I created a column with 5 rows, each with the same pop-up menu. I removed all other rows, so there are no blank rows at all, and inserted a footer row. So I had header row, 5 rows with the same pop-up menu, and a footer row. I then dragged the tab at the bottom left corner of the table and extended the table to add 10 more rows. Each of the new rows had a perfect copy of the pop-up menu.

        Marinka
        7 years ago

        Hi Gary,
        I had the same problem as Rick, but I think that the problem lies in categorizing.
        It works fine on a straight-forward table, but as soon as you start categorizing the cell-format doesn’t copy when adding a row.
        Do you know if there is a solution to that?
        Thanks,
        Marinka

          7 years ago

          No, sorry. I rarely use categorizing so I haven’t run into it.

    alan airdrie
    7 years ago

    how do i do the small “0” when i am typing degrees centigrade

      7 years ago

      Normally, when working in a text or word processing document, you use Shift+Option+8 to get the degrees symbol. But you don’t want to do that when using numbers in cells in Numbers — it will think of the content of the cell as a text string, not as a number. So leave out the degrees symbol.

      Jack
      7 years ago

      In need to work a rule so that if one column has a time and the next column has another time so that the difference of this can be reflected as text e.g
      8:00, 13:00 difference = 5 so this is > 4 = Not acceptable? or <4 is Acceptable

        7 years ago

        Look into using the IF function or one of the others like it.

    Dustin
    7 years ago

    I have a pop-up menu in Numbers, I would like to allow the user to enter custom data if needed, is this possible? If not is there another way to do something similar to a list that will allow custom data?

      7 years ago

      They could just delete the pop-up and enter their own data. Select, delete, type.

        Dustin
        7 years ago

        AWESOME! Thank you!

    rod
    7 years ago

    Hi Gary,

    Does Numbers offer a way to have a pop up calendar for a cell? When you click a cell, a calendar appears and then you can click on the date and that date would appear in the cell?

    Thanks for your input.

      7 years ago

      No, sorry, I don’t think that is an option.

    JBC
    7 years ago

    Use custom format. You can add/subtract any symbol, number, etc. Use dropdown menu for each element.

    Steve
    7 years ago

    How do I formatt cells to add and subtract time

    Hours and mins on the 24 hour clock
    Many thanks
    Steve

    Sara McGinnes
    7 years ago

    Hi Gary, Here’s a baby question: I can format a date column to forward one day for the next row, after row by selecting the date and pulling it to the next row. I haven’t been able to automatically enter each row one week ahead. Is this possible in Numbers 8. If so, can you tell me how?
    Thanks a lot,
    Sara

    Drew
    7 years ago

    Thanks new user – helped me out. :)

    DAVID
    7 years ago

    Hello Gary, i bought your book My Pages and i really like it so easy to follow, i was wondering if you have a book tutorial for Numbers too! Thanks!

      7 years ago

      Thanks! No, just Pages. I’ve got lots of Numbers tutorials here at MacMost, tho.

    Susan
    7 years ago

    Is there a way to format a series of 10 numbers in a cell to look like a telephone number (111) 111-1111?

      7 years ago

      Sure. Use the Custom format. Then play around with the interface there to create one like: (###) ###-####. But the # symbols need to be taken from the bottom portion of the interface. So you’ll need to experiment.

    ST
    7 years ago

    how to write a code that if one cell number is more than another cell number make the text green, else make the text red
    =If(B4>B4, text=green,text=red)
    thanks

      7 years ago

      You don’t use a formula for that. You use conditional formatting. Watch the video.

    Sheila
    6 years ago

    How do I format the cells to be text? I need some of my cells to be an equal sign and a number, but of course numbers thinks that I am inputting a formula, which I am not. This is driving me crazt. There does not seem to be a text format, or at least i can;t find it.

      6 years ago

      Select the cell. Then from the format bar, choose the Text format. (look where it has 1.0, $, %, checkmark, then a menu button — click on the menu button and choose Text).
      Then immediately type =whatever.

Comments Closed.