5 Replies Latest reply: Oct 17, 2007 10:26 AM by Marc Davies
Marc Davies Level 1 Level 1
There is a text format style for tiered numbers in "Numbers". The help file indicates how this can be used, but it looks suspiciously like the "pages" help file. Does anyone know if tiered numbering actually works in "Numbers" cells? And if so, how can one apply them?


G5 PPC, Mac OS X (10.4.9)
  • jaxjason Level 4 Level 4
    Open the users manual found on the install DVD/CD. Go to page 135. This lists how to use "Tiered List"s. I am not at my computer, so I cannot check.
    From the manual:
    In Numbers spreadsheets, you can place text in text boxes, table cells, and shapes.

    This would imply to me that the outlined text will appear inside the cell, as I read it, it says we can place text inside a cell, then it goes on to describe how to enter the outlined lists. I don't see anything talking about entering text into another cell to expand the list. just like entering a carriage return makes it show up as multiple lines of text in one cell. (wrapping does the same thing almost).

    Maybe its just the way I am reading it, But I am thinking it wouldn't handle a tiered list in multiple cells going down. What would happen if you inserted a row?

    Be interesting to find out, try it and let us know by responding to this post again,
  • 5|=vv Level 3 Level 3
    It seems that a fair bit of the Pages text formatting capabilities is implemented inside cells in Numbers. The "Text Inspector" panel give control them; the tiered numbering is accessed through the "Bullets" tab in that inspector panel. Note, though, that this seems to apply only within a cell. That is, a multi-line cell made with soft or hard returns can be numbered or tier numbered, but I see no way to number across cells using this in any reasonable fashion.

    In summary, it seems that you can have outline/numbered formatted items within a cell but not outlines/numbering across cells.
  • Marc Davies Level 1 Level 1
    Ah ha, thanks. That explains why the numbers show up in the cell when you select "tiered numbers". Shame it doesn't work automatically across cells - i'll just have to run a manual number system or work out a formula.

  • jaxjason Level 4 Level 4
    You could make a column that could be hidden that had what level of indent you wanted. then concatenate the REPT function results with a formula or text to create a certain number of spaces before the line of text within the cell. You could even use a text Bullet column and concatenate that in too.

    That Text bullet could be grabbed via a vlookup off a table using the indent level number on that row.

    If A had the indent level and B had the bullet text then C1 could contain a formula like this
    =rept(" ",a1) & b1 & "Indented Text goes here"

    Would that work for you?
  • Marc Davies Level 1 Level 1
    I can see where you are going and I like your thinking, but it assumes that my thinking and list is organised to begin with, which is rarely the case! I usually use outlining (in Pages for e.g.) then transfer to Numbers, but I still need to move things about from time to time. I guess what I'm looking for is a number system in column A for cells with entries in column B (not counting blanks) to define my top level. Then another column C with sub-numbers (decimal points) for any entries in cells in column D, level 2 etc. It just doesn't sit well visually. I could just use Pages, but I'm after an updatable scoring system in column Z (ish).

    Anyway, thanks for your solution.