Previous 1 2 Next 21 Replies Latest reply: Oct 29, 2013 11:23 AM by Peggy
AndrewJ99 Level 1 (0 points)

Numbers 3.0 is a real disaster as a lot of essential features have been removed.  I find it unusable for practical purposes.  How can i get back to Numbers 2.3?

MacBook Pro (Retina, Mid 2012), OS X Mavericks (10.9)
  • SGIII Level 6 (8,667 points)

    Hi Andrew,


    The old Numbers should still be on your machine, in a folder within Applications.


    On my machine I'm having no problems running both versions to see which is best for me.



  • AndrewJ99 Level 1 (0 points)

    Thanks that's helpful.  I found the old version.  It's actually under a sub-folder in Applications called iWork09.  However, how do I ensure that Numbers 2.3 is the default applicatiion rather than Numbers 3.0?

  • mischa2 Level 1 (0 points)

    I trashed the 3.0 version. It is of no use anyway...

    This reminds me fo FinalCut Pro a couple of years ago.

  • UmiB Level 1 (0 points)

    In Finder, select a Numbers document.

    Get Info. (File menu > Get Info or shortcut: Command + i)

    In the Get Info window go to "Open With:"

    Select the App and App version you wish to use from the menu.

    Click change all if you want to make that App version the default for such documents.

  • Danual Gordon Level 1 (0 points)

    I deleted V2.3 thinking it was V3 How do I get it back Im thinking I cant Formulas dont workScreen Shot 2013-10-25 at 7.40.07 pm.png

    In the first graf the months are in a drop down menu july has $1.00 and in th second graf the $1.00 shows up in july and june this happens in all but the 2 of the months. formula is in this photo to.

  • SGIII Level 6 (8,667 points)

    Hi Danual,


    If you haven't emptied your trash you can drag the old version from the trash back into the Applications folder.  If you want to keep the new version too, then you could first make a new folder within the Applications folder and drag from the trash into that new folder instead.


    If you have emptied the trash, maybe you can "restore" from Time Machine by going to the Applications folder there.


    Can't tell why your formula isn't working. You could try making sure the format of cell B1 and right is the same as the format of the cells in the Amount column, i.e. both text or both date-time. If they're date-time maybe make sure the value for July on Row 1 down below is exactly the same as for July in the Amount column, not different days or time, etc.  Any reason you leave out a July and a June in the Income table?



  • Danual Gordon Level 1 (0 points)

    I have emptied the trash so it gone, I done use timeline ( Maybe I should Start) I have checked the format of the cells and thay check out to I even tryed rerighting the formula I have reported the problem to apple. this Formula worked in V2.3 in this Month/dropdown menu page stile and it dosent in V3 maybe you can set up a simula page and test wether it work for you the month colum the list of months is a dropdown menu. I think it a bug that develpte during the redesine. I was reading someone saying thay were haveing formula problems to.

  • SGIII Level 6 (8,667 points)

    Hi Danual,


    Good idea to use Time Machine or some sort of backup!


    I can't reproduce the problem on my machine. Here's what I started with:

    Screen Shot 2013-10-25 at 10.42.45 AM.png


    I had the months in the row formatted as text to keep things simple:

    Screen Shot 2013-10-25 at 10.40.39 AM.png


    And the months in the income table chosen via a pop-up (I think you said that is what you are doing, though you might be better of with the using date-time since you will have months in more than one year):


    Screen Shot 2013-10-25 at 10.38.38 AM.png



    And even when I change the format to date-time it still gives the expected result:

    Screen Shot 2013-10-25 at 10.45.25 AM.png


    I think the app is doing what it is supposed to here. Perhaps you can try entering your formula again and fill right and see if that gives you the result you expect.



  • Danual Gordon Level 1 (0 points)

    Still cant fix this problem even after I pulled apart and put it back together



    Screen Shot 2013-10-26 at 7.57.28 am.png


    But on the iCloud server it proforms the way it should.

    Screen Shot 2013-10-26 at 8.07.10 am.png

    It posible that it only afects some uses, or older computers, my computer is 2010 Core 2 duo.

    I didnt put this Page together my self I got it of a Template all I did was change the color sceme and font size and put my info in

  • SGIII Level 6 (8,667 points)

    Hi Danual,


    In the formula click on the Amount and choose 'Preserve Column'.  Then hit return and take the formula and fill right.


    Screen Shot 2013-10-25 at 6.07.21 PM.png


    Does that fix the problem?



  • Danual Gordon Level 1 (0 points)

    Cant find Fill

  • SGIII Level 6 (8,667 points)

    Ah, one way is to select the cell B3 (after you've checked the Preserve Column and it shows a $ in front of the name), and move the cursor to its right edge until you see the yellow handle or whatever it is called.


    Screen Shot 2013-10-25 at 6.44.08 PM.png

    When you see the little arrows going left-right hold the mouse button down (or trackpad equivalent) and you'll see the cell turn into a yellow rectangle. Drag that yellow handle on the right edge to the right to all the other cells on that row where you have months above in row 1 ... you'll see the yellow rectangle expanding as you do this.


    Or, if that gets too tricky, you can simply click the cell, command-c for copy, select the cells you want to copy the formula to (C3 and right), and hit command-v for paste. Then in each cell you should see the same formula, with the only change being that B1 becomes C1 becomes D1, etc.



  • Danual Gordon Level 1 (0 points)

    At just put $0.00 in the colm directly right and this Formula

    Screen Shot 2013-10-26 at 10.14.48 am.png

    And in This Photo You can see that August and January and un afected by The Problem. and I have put difrent amounts in so you can see what month is conected to what month. it as if eg July and June in th formula for June the cell code is B1 like July. that is the way is acting.

    Screen Shot 2013-10-26 at 10.37.39 am.png

  • SGIII Level 6 (8,667 points)

    Here's how my setup looks here:

    Screen Shot 2013-10-25 at 9.00.13 PM.png

    And this is how the formula should look one column over to the right after you've filled right:


    Screen Shot 2013-10-25 at 9.03.23 PM.png

    Note that the only thing that has changed is B1 to C1. Everything else is the same. It's really important to have those $ "anchors" (the "Preserve Column") in the formula in B3 before you fill right to C3 etc.


    If you're having trouble try copying this formula:




    then clicking in B3 and pasting it in.


    BTW, if you're probably going to have more than one July (one in 2013, one in 2014, etc) you should format the Month column as Date & Time and also row 1 of the Budget table as Date & Time. Then make sure you type July 2013, August 2013 (i.e. month and year into each cell of each table where show each month). Though both month and year will be in the cell (actually Numbers will have month, day, and year: July 1, 2013, August 1, 2013...) you can tell Numbers to display just the month:


    Screen Shot 2013-10-25 at 9.14.17 PM.png




Previous 1 2 Next