A spreadsheet application developed by Apple as part of its iWork suite. The iWork equivalent of Microsoft Office Excel.

learn more… | top users | synonyms

12
votes
4answers
809 views

How to Change File Type Associations?

How do I stop Numbers from being the default program when a financial file is downloaded or imported?
0
votes
1answer
57 views

How do you formulate Microsoft Excel “if” statement equivalent in Numbers?

The syntax of a simple Excel if statement is: =IF(a1="a",b2,"") This places the contents of cell b2 in the current cell if cell a1 contains the character "a". Otherwise the current cell is cleared. ...
5
votes
2answers
2k views

Is there a keyboard short cut to edit a cell in Numbers?

Back when I used Excel you could easily do all the navigation and editing on a spreadsheet with the keyboard. I could navigate around with the arrow keys and hit F2 to edit a cell and start typing. ...
3
votes
2answers
11k views

Swap X and Y axes in Numbers?

I'm taking an economics course, and for whatever reason economists create graphs with the independent variable (price) on the Y axis and not the X axis. If I only have 1 dependent variable to graph, ...
2
votes
2answers
2k views

How to export Contacts version 9.0 data or .abbu file to .csv or other usable spreadsheet format

In the newest Apple Contacts version 9.0, how do you export all contacts or an .abbu file to a .csv file or other usable spreadsheet format? Dragging and dropping to Numbers does not work. Exporting ...
1
vote
1answer
123 views

Numbers for Mac: Force line chart to show axis at point (0, 0)

Look at this line chart. I wonder if its possible to force Numbers to show Y=0, for example, without needing to add a data entry point to make it happen. - Is it possible?
1
vote
1answer
4k views

How to plot a histogram to show occurrence of a certain number using Numbers

Sorry for this newbie question: I want to do something like in a column there are numbers 0.2, 0.3, 0.2, 0.4, 0.2 occur 2 times, whereas 0.3 and 0.4 occur once, I want to make make histogram that ...
0
votes
1answer
2k views

Numbers auto date on template only

Is it possible to use the =today() function (or something else) to insert the current date but then not update each time the file is opened? I want to create a numbers template for my invoices. I'd ...