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
2answers
3k views

Is it possible to do conditional formatting in Numbers for iOS?

Is it possible to do conditional formatting in Numbers for iOS? I'd just like to change the text or background colour depending on the cell's contents.
2
votes
5answers
4k views

Is it possible to remove cell borders from Numbers?

I imported an Excel spreadsheet that contained a few cells with black lines as their border. Is it possible to remove these outlines through Numbers (iOS)? I have tried copying and pasting, the ...
0
votes
1answer
201 views

Do I need to wait for an upload to complete before closing Pages/Numbers?

After updating a Pages/Numbers document in iOS, I can go back to the app's file browser to get the list of all of my docs in iCloud. At that moment, the document that I had just updated displays a ...
1
vote
2answers
89 views

Using the Numbers app, how to make 2 plus +0.25 become 2.25?

When a row in a table from a webpage is copied to the Numbers app, such as 2 3 4 5 and another row is copied, as some "deltas" (minor addition or subtraction): +0.25 0 0 -0.5 ...
5
votes
2answers
5k views

How can I change the data source of a chart in Numbers '09?

I have made a chart in Numbers '09 and now I want to create another very similar chart but with different data, so I have copied and pasted the chart and now I want to make it take its source data ...
5
votes
2answers
3k views

Numbers: Count unique items in a column

I'd like to count the occurrence of unique items found in one column of about 120 items. I can't find a way to do this in Numbers.app
2
votes
0answers
144 views

What is the Numbers keyboard shortcut to get in the formula bar of a cell?

I am looking for a keyboard shortcut in Numbers to edit the current cell via the formula bar (if that is the right word). Screen shot: Please note, I am not looking for this answer. That is how to ...
1
vote
0answers
83 views

Is there a way to have a formula in numbers 09 return an empty value (ie isempty() returns true?)

I've got a list of times and ages, and want to extract ages for a particular range of time values. So I've used an 'if' formula to copy the age for an entry if its time is between two values. The ...
5
votes
1answer
5k views

How do I do a pivot table in Numbers?

I can't find any equivalent of the Excel Pivot Table or Open Office Data Table features. I'd like to sum up my data grouped by values in various columns. For example, if I have A B C red ...
4
votes
2answers
1k views

How can I rename the columns in Numbers?

I'm working with a language file, with columns for different languages. My first row is the language names. Is it possible to have the "A", "B", "C", etc as language names instead. That way, when ...
0
votes
1answer
60 views

Cannot overwrite columns in Numbers for iPad

When i start writing text on my iPad in Numbers, i have to stay in one column and can't overwrite the next column. For example: I write something in Numbers on my Mac, the next column gets filled ...
5
votes
2answers
3k views

Link information between spreadsheets in iPad using Numbers

Could you link to data in one spreadsheet from another using Numbers for iPad?
3
votes
1answer
553 views

Is it possible to change text size & formatting of Numbers' formula input field?

Is it possible to set the text-size and possibly other formatting of the actual values/formula input field in Apple iWork Numbers? Comparing these two screenshots, it seems possible to set the size ...
2
votes
2answers
2k views

How do I move a row between two rows in Numbers?

Simple question. In iWork's Numbers, is there any way to move a row of data between two rows, as opposed to just plopping it on top of existing data? You can easily do this in Excel if you hold down ...
4
votes
1answer
102 views

How to convert and adapt from a “Save As” person to a “Version” person?

I am so used to "Save As" on the PC, so that for example, if I remember I removed a line two months ago on my resume (also called CV) and now is April 2012, I can go back to Resume 2012-01-23 ...
0
votes
1answer
205 views

Style text in Numbers formula

I have a numbers formula used in invoice generation: ="Invoice terms: "&CONCATENATE(Terms)&", please pay by ..." Which returns: Invoice terms: 14 days, please pay by ... Is there a ...
0
votes
1answer
1k 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 ...
2
votes
1answer
4k views

How can I use a secondary axis in Numbers?

One of my main problems with Numbers is the fact that it has much less of the functionality of Excel. That's why I barely use Numbers. One of the main things that I always thought impossible was ...
11
votes
4answers
721 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?
7
votes
2answers
3k views

How do I keep Numbers from mangling numbers when importing a CSV?

When I open a CSV file in Numbers, it "helpfully" converts fields it recognizes as numeric by stripping leading zeros, converting things it recognizes as dates, etc. Take for example, you type a UPC ...
2
votes
3answers
5k views

Can Numbers save a file as CSV?

I'm trying to switch over from Excel to Numbers. Is it possible to save a file as a CSV in Numbers? The whole idea behind this is I prefer to have my documents on the cloud as well as on Numbers for ...
2
votes
1answer
654 views

How to setup Indian rupee format in Numbers?

Indian rupee number format is different from US number format. e.g. 1,00,00,00,000 http://en.wikipedia.org/wiki/Indian_rupee How do I setup a custom number format in Numbers?
2
votes
1answer
4k 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 ...
4
votes
1answer
3k 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
116 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 , ...
2
votes
1answer
651 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?
2
votes
1answer
964 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?
6
votes
1answer
1k 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
105 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
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
1k 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
235 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
337 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
557 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
386 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
668 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
144 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
544 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
7k 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
514 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
791 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
3k 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
2answers
15k 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
504 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?