You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Converting from Numbers '09 to Numbers 6.0 for MacOS

I have been a user of Numbers from the day it was first brought out as part of the iWork package, maybe 2007? All my spreadsheets are currently in Numbers '09 format. Over the past couple of years, I have tried to update some of these to Numbers 6.0 but have run into annoying issues that always sends me back to using '09. Simple things like trying to get the date to format as yyyy mm dd. I have tried to make a custom date format but it does not seem to reformat text entered as 2020 02 04 to 2020 Feb 4 (as '09 easily does). I have also struggled with adding rows where formulaes are part of cells. The format of columns does not seem to be carried into the new row so for example, formulaes that including summing of columns have to be manually entered each time a new row is added.

Where can I find a clear, easy to read summary of all the changes that have occurred during the evolution of Numbers and how to do things in Numbers 6.0 that seem so easy in Numbers '09?

As you probably know, using Numbers '09 on more recent OS versions crashes if things like changing sheet or table names by double clicking is tried!

I know this post is a bit of a ramble but Numbers was a great application! What happened?

iMac, OS X 10.11

Posted on Feb 3, 2020 9:00 AM

Reply
Question marked as Top-ranking reply

Posted on Feb 4, 2020 5:19 AM

Maybe you need to spend more time with a recent version of Numbers.😀


For example, it is not true that "formulaes that including summing of columns have to be manually entered each time a new row is added." You put the formula in a Footer Row and refer to the entire column. You can see many examples of this in the templates at File > New in your menu. Also, I recommend spending some time at Help > Numbers Help in your menu.


SG



Similar questions

1 reply
Question marked as Top-ranking reply

Feb 4, 2020 5:19 AM in response to Baculo

Maybe you need to spend more time with a recent version of Numbers.😀


For example, it is not true that "formulaes that including summing of columns have to be manually entered each time a new row is added." You put the formula in a Footer Row and refer to the entire column. You can see many examples of this in the templates at File > New in your menu. Also, I recommend spending some time at Help > Numbers Help in your menu.


SG



Converting from Numbers '09 to Numbers 6.0 for MacOS

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.