# Questions tagged [numbers]

A spreadsheet application developed by Apple as part of its iWork suite availble for iOS, macOS and cross-platform via iCloud. It is the Apple alternative to Microsoft Office Excel.

499 questions
Filter by
Sorted by
Tagged with
195 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 ...
8k 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 ...
26k 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
1k 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 ...
143 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 ...
21k 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 ...
4k 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 I ...
77 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 ...
7k views

Could you link to data in one spreadsheet from another using Numbers for iPad?
1k 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 ...
6k 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 ...
119 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 ...
620 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 way ...
3k 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 ...
39k 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 ...
1k 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?
8k 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 ...
19k 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 ...
2k 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?
6k 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 ...
5k 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: "...
1k 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?
1k 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?
2k 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?
117 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 ...
11k 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 ...
6k 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. ...
900 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 ...
3k 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 ...
3k 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.
502 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: ...
1k 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?
1k 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 ...
6k 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?
318 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 editing cell C3, and set its formula to "=B2+C2". I would like to select cells B2 ...
7k 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?
3k 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. ...
29k 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: ...
6k 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. http:/...
915 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, ...
3k 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 ...
5k 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 ...
12k 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 |...
4k views

29k 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. I ...
602 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?
14k 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, ...