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
641 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
1answer
87 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
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.
5
votes
2answers
2k 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 ...
5
votes
1answer
870 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
1answer
713 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?
5
votes
3answers
702 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
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 ...
4
votes
2answers
810 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
2answers
85 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
2k 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
94 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
1k 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
3
votes
2answers
334 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 ...
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: ...
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
833 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: ...
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 ...
3
votes
1answer
265 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
1answer
133 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
2k 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
1answer
101 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
103 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
2answers
576 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 ...
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
1answer
442 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
2answers
8k 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 ...
2
votes
1answer
244 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
194 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 ...
2
votes
1answer
750 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
1answer
484 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
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: ...
2
votes
2answers
28 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
44 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 ...
2
votes
2answers
52 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 ...
2
votes
1answer
132 views

numbers: Copy/paste of cells messes up my formular

When I copy a cell (see picture 1) and paste it (see picture 2) the pasted version of the formular is messed up. As you can see there are some parts of the pasted formular which are not colored ...
2
votes
1answer
399 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
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 ...
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 ...
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, ...
2
votes
0answers
144 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, ...
2
votes
0answers
785 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 ...
2
votes
0answers
114 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 ...
2
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 ...
2
votes
1answer
280 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?
1
vote
2answers
156 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. ...
1
vote
1answer
505 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
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. ...