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

learn more… | top users | synonyms

1
vote
0answers
33 views

Latest Numbers changes, how to graph things?

Ok this is insane, I have a table Selecting both columns, and What i get back makes no sense. Plotting columns as series i get Plotting rows as series i get Things worked perfectly fine ...
1
vote
1answer
154 views

Insert MathType Equation is disabled in Numbers

I am running Numbers 3.1. When I try to select the Insert > MathType Equation... option, it is disabled. There doesn't seem to be anything in the help related to this feature. How can I use this ...
2
votes
0answers
41 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.
1
vote
1answer
306 views

Updating a chart dynamically in Numbers

Background: I've been having some sleep issues so I have started tracking my sleep habits along with some other data but so far, they are just entries in Evernote and as such it is not possible to see ...
3
votes
1answer
2k 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 ...
2
votes
2answers
770 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
173 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 ...
4
votes
3answers
6k 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 ...
1
vote
1answer
132 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 ...
3
votes
1answer
738 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 ...
2
votes
1answer
5k 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 ...
5
votes
1answer
5k 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 ...
1
vote
2answers
2k views

Can I remove items from my App Store updates

The App Store wants me to update my Pages 4.3 to Pages 5.0. Given the changes to and reviews of Pages 5.0, I wish to stay with 4.3. Can I somehow delete the upgrade reminder from the list? I ...
6
votes
3answers
126 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 ...
4
votes
1answer
825 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 ...
2
votes
1answer
2k 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?
1
vote
1answer
499 views

Numbers: How to change cell text conditionally?

I am trying to change the text of a cell in Numbers 3 according to a condition. E.g. if A1-A2 is a negative value, the text shall be 'Negative'. If the value is positive the text shall be 'Positive'. ...
0
votes
1answer
1k views

Insert date & time in latest version of Numbers

I've looked around online and have found references to an "Insert => Date & Time" capability in Numbers for OSX. But it's not there in my version of Numbers (3.0.1 -- 1483). Has this capability ...
3
votes
1answer
355 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 ...
4
votes
2answers
245 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 ...
5
votes
2answers
3k 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
3answers
9k 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: ...
0
votes
0answers
37 views

iWork Numbers 3: detect change in row

I'd like to update the datetime in a cell whenever any cell in the row changes. Is this possible in iWork Numbers 3? If not possible to look for changes in entire row then perhaps only "watching" a ...
0
votes
1answer
39 views

Where has Numbers gone?

I created several spreadsheets in Numbers. Lately I have been using Excel, which won't open them. I can't find Numbers in my application folder--is it hiding somewhere??
0
votes
1answer
1k views

Mac Numbers date functions

Can I colour a cell red if todays date is on or after the date I have entered in the cell? I have tried the IF function and conditional formatting but cannot make it work...
0
votes
2answers
51 views

Numbers.app - How do I add a series of columns

I have a spreadsheet with about 600 rows and 20 columns. I want to add a unique identifier to each cell so that I can use the exported CSV output in another app. So I thought that I could add a ...
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.
2
votes
1answer
3k views

Numbers Won't Open On My MacBook Pro with OS X 10.8.5

I'm not a tech or computer expert - I understand clear directions, but not tech-speak, so I'm going to put this as plainly as I can… I've updated to the most recent system, OS X 10.8.5, on my MacBook ...
0
votes
1answer
222 views

Any suggestions for an ultra-lightweight spreadsheet-like application?

Does anyone have a suggestion for an ultra-light spreadsheet application which is very fast and snappy? I do most of my deep analysis using advanced statistical programs and I manipulate ...
1
vote
1answer
1k views

New Numbers has no Auto-Complete?

It would appear that my documents in Numbers (since upgrading to 3.0 with Mavericks) no longer auto-complete cells. I've Googled for "turn on auto-complete in Numbers" and found plenty of questions ...
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 ...
0
votes
1answer
96 views

Numbers has stopped showing up in Launchpad

Numbers has stopped showing up in Launchpad. How can I add it back?
1
vote
0answers
102 views

Is there a way to create a polar plot in Numbers?

I am trying to do a polar plot, or radar chart as excel calls them, for a report. I don't have excel, only Numbers, is there a way to do that type of plot with Numbers? I can't seem to find a way. The ...
1
vote
1answer
72 views

Performance of Numbers 3.0 for large calculation sheet

When I used previous versions of Numbers to work with files containing a lot of large formulas, the performance of many actions were slow, including scrolling. Can you comment how about the latest ...
0
votes
1answer
22 views

Numbers floating sheets

In Numbers, how can I get the spreadsheet to remain stationary on the page? I have tried to double tap thinking that would display and anchor the sheet but it doesn't work.
1
vote
1answer
562 views

How do I sum up specific things in Numbers?

I have a spreadsheet in the newest iWork Numbers.app, with something like: CATEGORY | POINTS HW | 100 HW | 100 NW | 12 HW | 50 NW | 23 I want to just sum up all the ...
0
votes
2answers
353 views

Numbers regex for stripping domain from email address

I have a field that contains email addresses, I want to use regex to strip everything before the @ symbol to give me just the domain e.g. john@apple.com => apple.com jill@apple.com => apple.com ...
0
votes
2answers
455 views

Numbers spreadsheet can't be imported

I have a spreadsheet I have been updating in IOS Numbers for several months and I sometimes update it with OSX Numbers However when I did a recent update in OSX I get the error message Spreadsheet ...
1
vote
0answers
118 views

Exporting CSV with Numbers with different languages

I am exporting a file from Numbers to CSV and it contains language other than English, like Japanese or Russian. After I export the CSV, all these funny characters shows up in the CSV. Is there a ...
2
votes
1answer
2k 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
1
vote
1answer
486 views

Converting a float to hours:minutes in Numbers

Probably this is a very easy thing to do, but as handicapped as I am using Apple's iWork applications, I just can't find it. I have made a calculation in Numbers which results for example in 14,25 or ...
2
votes
1answer
33 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 ...
0
votes
1answer
80 views

How to stop Numbers from beeping at me when I use the arrow keys?

When I edit spreadsheets in Numbers, I often hold down the left or right arrow key to get to the far-left or far-right column of a table. Numbers always beeps at me when I do this. It seems to think ...
1
vote
1answer
193 views

How to disable default alt-left / alt-right keyboard shortcuts for Numbers.app

I'm continually hitting Alt+Left Arrow to move navigate within a cell in Numbers, and inadvertently inserting new rows.. How can I disable all the Alt+Arrow shortcuts? I've tried changing the ...
1
vote
1answer
271 views

Select statements in Apple Numbers '09

I've got a table as follows | Name | Year | Price | |____________|_______|_______| | Foo | 2013 | $10 | | Bar | 2009 | $3 | | Baz | 2010 | $100 | What I'd ...
3
votes
1answer
298 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
2answers
58 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 ...
1
vote
1answer
1k views

How to convert a Numbers file to .pdf and still have its formula work

Is there a pdf creator or something that I can convert my Numbers file with all its formula still working. The file is a price calculator with choice of products. I dont want the client to change ...
0
votes
1answer
565 views

Making and applying a custom design to a chart in Numbers

I'm making a column chart about certain dice rolls in the game Descent: Second Edition, and the problem I'm having is that there are multiple dice of the same color in the standard rolls. For example, ...
2
votes
1answer
163 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 ...