How do I downgrade back from Numbers 3.0 to Numbers 2.3

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.

SG

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

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

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.

I deleted V2.3 thinking it was V3 How do I get it back Im thinking I cant Formulas dont work

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.

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?

SG

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.

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:

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

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):

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

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.

SG

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

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

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

Hi Danual,

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

Does that fix the problem?

SG

Cant find Fill

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.

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.

SG

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

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.

Here's how my setup looks here:

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

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:

=SUMIF($Month,B1,$Amount)

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:

SG

Hi Andrew,

how do I ensure that Numbers 2.3 is the default applicatiion rather than Numbers 3.0?

I have found the answer by UmiB will not stick. It reverts to Numbers 3.0

My workaround is to drag icons for Numbers 2 and Numbers 3 onto the Dock. Both apps are in the Application folder. Numbers 2 is inside a folder called iWork 09. You can have both versions running at the same time.

Caution: do not save an old document in Numbers 3 if you want to keep it as Numbers 2 format. You can tell which version is open from Menu > Numbers > About Numbers.

Regards,

Ian.

Message was edited by: Yellowbox. You can tell which version is open from Menu > Numbers > About Numbers.