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

learn more… | top users | synonyms

70
votes
3answers
25k views

Why does Numbers hide a huge PNG file in exported Excel sheets?

OK, this is a weird one. I take my blank Numbers sheet: ...and export it to Excel: Whoah, that seems a little large. Let's rename the Excel doc to .zip and have a look inside: Digging a ...
12
votes
4answers
40k views

How can I do text-to-columns in Numbers?

I've got a column where each cell in the column contains two different pieces of data separated by a known delimiter ", ". How can I split each cell in this column around the delimiter? Given: ...
12
votes
4answers
885 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?
9
votes
2answers
4k 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. ...
8
votes
1answer
7k views

Swap X and Y axes on Numbers 3.1

This link is now outdated with the new release of numbers. I want to transpose the X- and Y-axes on a chart in Numbers 3.1. How the heck can I do this? The first chart I made was able to sum my ...
8
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?
7
votes
2answers
13k 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: ...
7
votes
1answer
13k views

How to uninstall Numbers and Keynote on Mavericks?

I installed Pages version 5 on Mavericks via the "App Store". But the problem is Keynote and Numbers are installed also. I'm not interested in Keynote and definitely not in Numbers. I want to ...
7
votes
2answers
6k 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 ...
7
votes
5answers
22k views

How to gracefully import CSV files into Numbers.app v3?

I have a process, which has worked faithfully for years in Numbers '09, whereby I download my Bank account data in CSV format, then drag that data directly into my Numbers sheet (after creating an ...
6
votes
1answer
24k views

How to create sum in Numbers up to a specific row?

I have column which contains prices for my work. The last row of that column should contain the total. Currently I have to adjust the SUM() calculation every time I add or remove a row. Can I somehow ...
6
votes
2answers
5k views

Numbers v3.1: Automatically link URLs in spreadsheet?

I've inherited a spreadsheet that has a loooong column (thousands) of URLs, all unclickable. I'd like to make them clickable. I have tried the following: Highlighting the column. Select column, ...
6
votes
1answer
13k 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 ...
6
votes
1answer
643 views

Can I use Javascript to write a custom function for Numbers?

It's always annoyed me that I can't write a custom function for Numbers. It would make the spreadsheet so much more useful to me. In Google Apps spreadsheets you can do it, using Javascript. In ...
6
votes
3answers
175 views

Is this possible to link the value to a database in Apple's iWork suite?

For example, I would like to make a Pages document that has a value that's linked to the company information and Keynotes and Numbers as well. So, when our company information changes, all the ...
5
votes
2answers
10k 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
5
votes
3answers
12k 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 ...
5
votes
3answers
17k 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.
5
votes
2answers
7k 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
15k 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 ...
5
votes
2answers
10k views

COUNTIF using two conditions from data inside and outside the dataset

I'm struggling to use numbers to do a function. Specifically, I want to use COUNTIF to check two things within my data set table and put that information into another table that we'll call "query ...
5
votes
1answer
126 views

How to calculate max with condition in Numbers?

How can I calculate max with condition in Numbers? In other words, I want something like maxifs, which operates max operation instead of sum operation for sumifs.
5
votes
2answers
5k views

Link information between spreadsheets in iPad using Numbers

Could you link to data in one spreadsheet from another using Numbers for iPad?
5
votes
3answers
2k views

How to store new iWork (2013) documents in a flat file (for version control)?

With the October 2013 iWork update, the new UI is great but it seems one cannot store documents as 'flat file' any more. This really limits my ability to store the files, essentially ruling ...
4
votes
2answers
2k 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 ...
4
votes
3answers
4k 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 ...
4
votes
1answer
5k views

Keyboard shortcut to delete row in Numbers

I can add rows conveniently using Option+Shift+Up Arrow (insert above) or Option+Shift+Down Arrow(insert below). Is there a keyboard shortcut to delete the current row?
4
votes
1answer
111 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 ...
4
votes
3answers
1k views

Numbers: Countif with condition the content of a cell

I am struggling to come with a solution on this problem, making me wonder if the Countif function is designed to work this way, or what is wrong with my syntax at the end. I have my first table with ...
4
votes
1answer
4k 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: ...
4
votes
1answer
5k views

How do you rotate a cell in Numbers (3.2)?

I want to rotate the header row by 45 degrees to look like this (from Excel). How do you do this in Numbers?
4
votes
1answer
612 views

Numbers: Grouping daily data into weekly data

I have a spreadsheet where I am keeping track of several statistics on a daily basis. I have another spreadsheet where I am keeping track of several statistics on a weekly basis. I want to graph the ...
4
votes
2answers
950 views

How to write AND condition in Numbers

I have a dataset where I want to write a COUNTIFstatement in Numbers (Mavericks). Specifically I want to count if a number is between 16 and 30. So far I have tried: COUNTIF(test-array, ">15 AND ...
4
votes
1answer
432 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: ...
4
votes
2answers
119 views

How to get the month name in English using Numbers?

I'm using Apple Numbers v 3.6.1 on OS X 10.11 to automatically fill all the info I need to generate a receipt each month. "... " & MONTHNAME(MONTH(TODAY())) & " 1 − " & ...
4
votes
2answers
1k views

Numbers no longer opens .xls spreadsheet

I have very recently converted to a MacBook Air from a PC and have a 1.3mb .xls file which 1 week ago Numbers happily opened, edited and saved in its own format. Today, when I opened it it was ...
3
votes
2answers
340 views

Numbers: Make numbers negative

In Numbers, how can I convert a number to negative. E.g. 200 233 186 Becomes -200 -233 -186 In Excel, you can use tools like Paste Special, but these don't exist in Numbers.
3
votes
2answers
7k views

How to display zero value as blank cell in mac numbers 3.1

How do I display zero value as blank cell in mac numbers 3.1 yet maintain a formula. I want a running balance column that only shows balance to the line of the last entry like a checkbook register. ...
3
votes
1answer
7k 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 ...
3
votes
3answers
7k views

How to change the colors of individual bars in Numbers 3.2

How do I change the colors of individual bars, in a bar chart of in Apple's Numbers 3.2.x
3
votes
2answers
4k 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 ...
3
votes
2answers
2k views

Can't email Numbers 3.0 or Pages 5.0 documents via Google Mail (Gmail)

When I try to email a Numbers 3.0 or Pages 5.0 document via Google Mail, I receive the following error.
3
votes
2answers
13k 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
12k 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 ...
3
votes
2answers
90 views

The SUM function in Numbers 3.6.1 on my Mac OS X10.10.5 isn't calculating correctly. Why?

You can see in the attached screenshot that I have used the SUM function to add the values in column E. There are several "1" values (you can see one in cell E126) but the SUM always comes out at ...
3
votes
1answer
451 views

What's the Numbers equivalent to Excel's “A1:A10-B1”

I'm switching from Microsoft Excel to Number.app, in Excel you can do =SUMPRODUCT((A1:A5-A1)^2,B1:B5) the a1:a10-b1 bit will return a cell range equivalent to a1:a10 but with all the cells ...
3
votes
1answer
914 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 ...
3
votes
3answers
8k 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 ...
3
votes
1answer
830 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 ...
3
votes
3answers
5k views

Auto-Populate A Pop-Up Menu in Numbers 3.5

I'm trying to steer clear of Excel, despite my sister's nagging, and I've done pretty well to create a Quote and Invoice workbook in Numbers. The problem I am having is working out how to ...