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
2answers
40 views

Keyboard shortcut for prev/next sheet in Numbers 3

is there a keyboard shortcut for moving to the next or previous sheet in Numbers 3? I have a dream I found those shortcuts, but can't seem to figure out what they were...
0
votes
0answers
36 views

Numbers 3.1: Maintain Link to CSV

Is there a mechanism to maintain a link between a CSV that may change and a Numbers file? I would like to maintain a Numbers file that uses table data from a CSV whose contents will be updated every ...
0
votes
0answers
29 views

Map date and time entries to single day in Numbers

I am keeping track of a certain value that varies during the day, and from day to day. I make entries in my Numbers table as I get the values during the day. Column A is the time entry: month day year ...
2
votes
2answers
79 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 ...
1
vote
1answer
27 views

Tracing the forward use of values in formulas in Numbers

I use Numbers version 3.1 on Mavericks. One can easily look at a formula in a given cell and immediately see the other cell references it uses. I think of this as a backwards look. Does any means ...
2
votes
0answers
29 views

Numbers 2: Create a new header cell, listing once the contents of a column

Not sure how to search for this question, and moreover I rather think that what I want might not be possible, but just in case I am asking it here. I am looking for a way to create a new table where ...
3
votes
1answer
290 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
72 views

How do I sort a Numbers' table using data from another table?

So, I've got this data set coming from questionnaires. I created one table per question, questionnaires in rows, answers in columns, and everything is fine and dandy, but now I have this situation ...
2
votes
2answers
897 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. ...
1
vote
0answers
72 views

How do you get different color bars in Numbers 3.1?

In previous versions including 3.0 when you made a 3D Bar chart each data point (ie. months) would be in a different color - now I can't seem to find any way to make them different. Is this a bug in ...
1
vote
0answers
28 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
90 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
37 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
120 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
897 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
430 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. ...
0
votes
0answers
30 views

iMac OS X 10.9.1

I am a new user of Macs and Numbers and need a little help. I am creating a Numbers page for a game I play in which I have multiple trains with various loads they can carry. I have entered this data ...
2
votes
1answer
119 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 ...
3
votes
1answer
3k 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
73 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
352 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
2k 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
3k 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 ...
0
votes
0answers
14 views

Copying - Old Version vs. New Version of Numbers

I use Numbers for a relatively primitive way to catalog books I have read. The old version would copy the date (month/year) and the author's name once I entered the first couple characters. Now I have ...
1
vote
2answers
737 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
2answers
112 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
395 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
928 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
298 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
464 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
219 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
142 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 ...
5
votes
2answers
4k 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
28 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
692 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
42 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 ...
2
votes
1answer
2k 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
175 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
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 ...
0
votes
1answer
82 views

Numbers has stopped showing up in Launchpad

Numbers has stopped showing up in Launchpad. How can I add it back?
1
vote
0answers
85 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
66 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
0answers
27 views

Concatenate rows of variable length to a single row in Numbers?

I'm currently trying to write a spreadsheet for scoring students on papers while also storing the maximum amount of points achievable. Each week, a new paper is released with a number of exercises ...
0
votes
1answer
18 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
171 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
160 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
0answers
42 views

How to maintain capital letters within a Numbers files exported as a CSV file?

I imported a CSV file into Numbers which contained emails, phone #'s, first and last names. I cleaned up the data in Numbers so that names started with capital letters and phone numbers contained ...