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

learn more… | top users | synonyms

3
votes
3answers
5k views

Why can't I see my Numbers spreadsheets on my new iPhone?

I had been using Numbers on my iPad and on my iPhone 4. The spreadsheets were synced perfectly over 3G and wifi. However, I just bought an iPhone 4S. The spreadsheets are missing when I open ...
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. ...
2
votes
1answer
271 views

Numbers: How can I display negative values in a column chart?

I am using Numbers '09 v2.1 (436) and I have a table having positive and some negative values. When in my project I add a column chart mapping properly data from that table it displays a chart without ...
1
vote
1answer
1k views

hyperlink to another worksheet in Numbers 09

Is it possible to hyperlink to another sheet in the same workbook in Numbers '09? I want to have a link so I can jump back and fourth between sheets. Excel has this feature but I can't find anything ...
2
votes
1answer
1k views

How do I insert radio buttons in Numbers for iPad?

I need to insert radio buttons on a Numbers spreadsheet. I tried importing an Excel document with form radio buttons, but it did not pull through. Advice would be appreciated.
3
votes
1answer
346 views

Is there an equation in Numbers that will give me the sum of numbers based on a separate column?

I'm trying to find out if there is a way to create an equation that looks at one column, if it is equal to a certain value, then add the value in the other column? Example: #Table of running values: ...
0
votes
1answer
602 views

iWork Numbers evaluate string

I have a cell with the following content 2262/4121. I want to have a cell next to it that contains the result of that expression. Is there a function for that?
2
votes
1answer
443 views

In Numbers, how can I determine the default formatting of cells in rows that have just been added to a sheet?

When using Numbers, I have noticed that whenever I add a new row above existing rows, all of the formatting for the new row is exactly like the rows below it. However, if I add a new row below ...
2
votes
1answer
828 views

exporting numbers 09 to excel with photos in spreadsheet

When I export my numbers spreadsheet with photos in the column the photos do not transfer when I import it into excel. How can I do this?
0
votes
1answer
148 views

Numbers: hotkeys to choose cells in formula edit mode

When I edit formulae in Numbers, is it possible to select nearby cells using the cursor keys? For example, I might be editting cell C3, and set its formula to "=B2+C2". I would like to select cells ...
1
vote
1answer
2k views

Numbers: divide in a column

I have a price list: 12,560 14,340 11,890 ... Is there a simple way to divide these cells by a number at once?
1
vote
1answer
651 views

Can tables from Pages be reused in Numbers to create graphs?

I created a table in Pages '09 and pasted it into Numbers '09 to see if it worked, then I created a graph for it, still in Numbers, but the graph displayed no data as you can see from the screenshot. ...
0
votes
1answer
8k views

Is there a way in Numbers to flip columns with rows?

Is there a way in Numbers to flip columns with rows ? I have several tables in my sheet and I need to swap columns with rows for each table. e.g. A1 A2 A3 B1 B2 B3 C1 C2 C3 should become: ...
0
votes
1answer
2k views

how can I convert the values of a table into percentage values rather than absolute values?

In Numbers, how can I convert the values of a table into percentage values rather than absolute values ? The percentage are computed per column. The sum of the cells in a column is 100%. i.e. ...
2
votes
2answers
533 views

What causes all iWork apps to have blank, unusable documents after a reinstall?

After deleting and re-installing the apps, I can't use iWork. Specifically, the document area is always empty, no matter if I create a new document or open an existing one. This applies to Pages, ...
1
vote
2answers
905 views

Copy static cell value in Numbers

In numbers I have a table that contains some configuration values, I reference these in formulas but when I copy and paste the cells using the configuration values it breaks as it increments the cell ...
3
votes
2answers
3k views

iWork '09 Keeps asking to be Registered

I'm a teacher in a classroom with 8, 9 10 and 11 year olds who each have a macbook or a macbook pro. Fun job. We have a standard 10.6.6 image with iWork '09 (4.03). In previous images, iWork would ...
0
votes
1answer
4k views

Conditional SUM() based on text of a cell using iWork

I have some basic data Name | Amount Jake | 10 Jake | 12 Jake | 13 Ben | 1 Ben | 14 Ali | 9 Ali | 4 I want to total up the amount for each person so I end up with something like Jake | 35 Ben ...
2
votes
3answers
16k views

How to import a spreadsheet into Numbers from an email attachment?

I want to know how to open a spreadheet email attachement in the Numbers app on the iPad. Here are the steps I have taken with no luck: On the iPad I open my email. I see a spreadsheet attachment. ...
1
vote
1answer
512 views

Will EXCEL formulas be OK if they are imported within a spreadsheet into iPad Numbers?

Will EXCEL formulas be OK if they are imported within a spreadsheet into iPad Numbers?
3
votes
2answers
10k 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, ...
3
votes
2answers
10k views

Can Numbers ’09 import an Excel XML file?

Can Numbers ’09 (part of the iWork suite) import XML files? Specifically, the format created by Excel when exporting as "XML Spreadsheet 2003." I can't just use Excel's native format because the ...
5
votes
3answers
9k views

How to convert .number file to any of the readble format including excel and pdf without having mac

I have an important .number iworks file. My Mac is now no more... How do I convert .number file to any of the readble format including excel and pdf without having mac.