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

learn more… | top users | synonyms

2
votes
1answer
3k views

iWork '09 Numbers: How to set the default language of the document

I would like to set the default language of a Numbers document. I figured out how to do it for a Pages document: How Do I Set the Default Language in Pages? but I cannot find the corresponding ...
3
votes
1answer
2k views

How do I open XLS files in Numbers?

I've just bought Numbers and I'm trying to open some XLS files. They're in Excel '97 format, not encrypted, and with no password set. However, when I try to open them, I get this error message: ...
0
votes
0answers
107 views

How do I evaluate multiple equations in a single cell?

I have two equations in a Numbers spreadsheet: COUNTIF(PROMO,FALSE) COUNTIF(Purchases :: WL,FALSE) I need to merge these to satisfy one cell's value. Something similar to countif( A && B , ...
1
vote
1answer
506 views

Transfer values between tabs in Numbers for iPad

I have two tabs in one spreadsheet in my Numbers for iPad. Is there a way I can transfer a value between those tabs?
1
vote
1answer
739 views

Floating row in Numbers for iPad

Is there a way I can make a row float on top of everything else. So, no matter how many rows you add, the row will always be visible?
5
votes
1answer
714 views

Keyboard Shortcut to Fill Right in Numbers?

In Numbers, is there an equivalent keyboard shortcut to Excel's "Fill Right" Ctrl + R and "Fill Down" Ctrl + D?
2
votes
1answer
99 views

How do I insert a function along with a word in numbers

I am using numbers and I have a column function at the footer row. I'd like it to produce a Countif() along with a word. I tried: =Countif(Checkboxes,True) "Checkboxes" so that it would express for ...
3
votes
2answers
3k 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 ...
4
votes
2answers
812 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. ...
1
vote
1answer
185 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
922 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.
2
votes
1answer
303 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
392 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?
1
vote
1answer
272 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
281 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
121 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 ...
0
votes
1answer
990 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
273 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
5k 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
1k 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
429 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, ...
0
votes
1answer
602 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 ...
2
votes
2answers
2k 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
2k 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 ...
1
vote
2answers
12k 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
471 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
8k 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
9k 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
6k 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.