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

learn more… | top users | synonyms

10
votes
4answers
669 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?
6
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 ...
6
votes
1answer
845 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?
6
votes
2answers
103 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
3answers
7k 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
4k 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
1answer
2k 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 ...
5
votes
2answers
2k 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: ...
5
votes
1answer
3k 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 ...
5
votes
2answers
2k 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
1k 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
683 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
2answers
2k 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
4
votes
2answers
976 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. ...
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: ...
4
votes
2answers
118 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
2answers
1k 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 ...
4
votes
1answer
246 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
1answer
97 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 ...
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, ...
3
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 ...
3
votes
1answer
230 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
3answers
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 ...
3
votes
1answer
323 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: ...
3
votes
1answer
501 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 ...
3
votes
2answers
55 views

How to convert a chain into a number

In Apple Numbers I want a cell to have 4x8x7 (or 4*8*7) to show the detail of the volume, and in another cell I want that volume calculated 4*8*7=224 based on the first cell. But it doesn't consider ...
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.
3
votes
0answers
213 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, ...
3
votes
1answer
2k 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 ...
3
votes
1answer
251 views

Numbers: conditonal highlight based on a date in a different column

In numbers, I would like to change the background colour of Column D based on whether the date in Column A is still in the future (i.e. graying out). I can get the colour formatting to work on the ...
3
votes
1answer
175 views

Numbers 3 - How to apply custom chart style

Using Numbers 3.0 with Mavericks. I am creating a bunch of scatter plots in numbers. I want to remove the big bubbly data point symbols and simply display the data as connected points. Setting this ...
2
votes
3answers
3k 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
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 ...
2
votes
2answers
311 views

Connecting MySQL DB to Apple iWork Numbers?

I'd like to visualize some data from a MySQL database using a Mac, but it hasn't been easy finding a solution to this. I understand Excel has DB connectivity, but currently I only have Apple Numbers. ...
2
votes
1answer
571 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
2answers
13k 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. ...
2
votes
2answers
66 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 ...
2
votes
1answer
698 views

How to change cell background color in numbers according to some rules?

Making it simple, using Numbers, how can you set up the following: If number is positive make background cell green, else make it red
2
votes
1answer
604 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?
2
votes
1answer
31 views

How to make Numbers accept the “.” instead of the comma “,” when inserting data?

I'm from elgium. In Dutch, as probably in some other languages, you write numbers like this: 3,141592, where in English it'd be 3.141592, but the Numbers app only interprets my input as a number when ...
2
votes
1answer
959 views

Numbers: Can I highlight the row and column of the selected cell?

When reading larger spreadsheets, it would be helpful to highlight the row and column that the currently selected cell is in. I'm not talking about conditional formatting or anything in the ...
2
votes
2answers
1k 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 ...
2
votes
1answer
2k 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 ...
2
votes
1answer
540 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
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
28 views

How to handle Numbers' automatic Data Formatting?

I'm trying to put together a sheet that calculates hours I work. One thing I want to do is calculate hours that are billable. So I have something like this: Things that aren't billable or are ...
2
votes
1answer
16 views

Sequential numbering for pseudo-“Rows”

tl;dr: Formula to number rows that doesn't break when some "rows" are made of multiple, merged spreadsheet rows. Scenario: I am making a check-list (of things to look at when apartment-hunting) in ...
2
votes
2answers
64 views

Directory contents into a spreadsheet entry

I would like to turn the contents of a folder into entries for Numbers (or Excel) - is there a way to automate doing this?
2
votes
1answer
69 views

Reinstall Numbers?

I got myself into a state where App Store says that I have numbers "installed" but in fact I don't have it installed. I tried the recommended option/click and shift/click over the installed button and ...