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

learn more… | top users | synonyms

3
votes
1answer
251 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
198 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
1answer
12 views

Can I have multiple graphs in the same place in Numbers?

I have a spreadsheet with a bunch of graphs based on a table. Instead of having a long list of graphs, is there a way to display these graphs all in the same space, but change between them? And to ...
2
votes
1answer
91 views

OSX Numbers 3.2 inserting date / time

I want a cell to take on the date and time of "this moment", and then leave it. Contrary to some experiences I've read about, the Insert menu does have Date & Time, but it doesn't seem to respect ...
2
votes
1answer
204 views

Numbers: How can I display negative values in a column chart?

I am using Numbers '09 v2.1 (436) and I have a table having positive and some negative values. When in my project I add a column chart mapping properly data from that table it displays a chart without ...
2
votes
1answer
396 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
1answer
32 views

How do I change the sheet color in Numbers 3.x?

Right now the sheet color is white. But it is hard on my eyes. How do I change the sheet color to black? I'm using a Numbers 3.x in OSx 10.9.3
1
vote
1answer
28 views

One Odd-Sized page in Pages Document for PDF

Need to embed a Numbers spreadsheet in a Pages doc that will “live” as a PDF. Generating a scaled image that I then embed results in mediocre resolution.
1
vote
1answer
70 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 ...
1
vote
1answer
181 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 ...
0
votes
1answer
9 views

Change date format in Numbers 3.2

I recently updated Numbers to 3.2. I want to be able to put a date in a cell numerically (8-22-14) and then have it show up with the month name, day, and year (August 22, 2014) without having to do a ...
0
votes
1answer
16 views

Can't find SUMIF in my Numbers functions. Could someone tell me where to find it?

For the first time I am working with Numbers rather than Mac Exel, which I was running on my old G4. I now have a 2012 MacBook Pro with Mavericks, and the one function I use more than any other is ...
0
votes
1answer
38 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??
2
votes
0answers
27 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 ...
2
votes
0answers
66 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
0answers
36 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.
2
votes
0answers
125 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 ...
1
vote
0answers
13 views

How can I restore an older version of a Numbers document (before the sync)

I'm using Numbers on my iPad and my Macbook. Yesterday I opened my Macbook and for some reason it opened the Numbers app but didn't sync. I didn't really need to work on the file so I just left it ...
1
vote
0answers
45 views

Can't use any of the iWork apps

I'm unable to use any of the apps included in the iWork package. If I try to open any one of them, the app opens but I can't perform any action. I click on the bar menu items to see that even 'About ...
1
vote
0answers
29 views

Sum of Formula results?

Is there any way in Apple Numbers to apply a formula to a selected set of rows, and sum up the results? This is how i'd like to have/use the formula SUM(TableA::$A$1:$A$20;"=$1*"&TableB::A1) ...
1
vote
0answers
361 views

How Do i Pivot Table in Numbers 3.2?

I'm new to Numbers and currently using Numbers 3.2. I already got a clue of how to use SUMIFS to create Pivot Table in Numbers. But i'm still looking for a better answer of how to generate the ...
1
vote
0answers
33 views

How to write a function in Numbers to get the DATES for different tasks

I am trying to figure out how to write a function to get Dates going on and back from a different moments in my to-do spreadsheet. I know that i can use function DATEVALUE() to count from one specific ...
1
vote
0answers
26 views

Numbers '08: How to create a histogram?

I have data (ranging from 0 to 1, e.g. 0.61 0.23 0.99 1.0 0.89 0.0 0.42 0.42 0.86 and I would like to create a histogram with bins 0 0.2 0.2 0.4 0.4 0.6 0.6 0.8 0.8 1.0 with the upper ...
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
0answers
76 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
0answers
93 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 ...
1
vote
0answers
297 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 ...
1
vote
0answers
74 views

Is there a way to have a formula in numbers 09 return an empty value (ie isempty() returns true?)

I've got a list of times and ages, and want to extract ages for a particular range of time values. So I've used an 'if' formula to copy the age for an entry if its time is between two values. The ...
0
votes
0answers
18 views

Numbers never responds

When I try to run Numbers, it bounces for a while, and then just stops. No windows, no menu bar, nothing. When I Ctrl-click the icon, it says not responding, so I force-quit. I have never actually ...
0
votes
0answers
11 views

Does numbers have a way to auto-fill an entire column?

Excel has a feature where when you are trying to auto-fill equations (i.e. you can drag an equation down and it makes an appropriate equation for the next row), you can double-click the drag-handle ...
0
votes
0answers
17 views

Entering only the time in a iOS Numbers form

I use Numbers on my iPhone to keep track of a few things that have well-defined attributes. Each of these documents has a sheet that acts as a simple database, and a form that I use to enter rows into ...
0
votes
0answers
9 views

Numbers 'Not Responding'

I have a problem opening one particular Numbers spreadsheet on some of our computers but not others. All are running 10.8.3 any clues? I have tried changing the file name, holding down the shift key ...
0
votes
0answers
10 views

Loading xlsx file in Numbers, Filter Table is disabled on columns

I loaded an Excel file (XLSX format) with a table in Numbers, where I had filtered out some data based on a column (using Excel's column-based filtering options). In Numbers, I only see the filtered ...
0
votes
0answers
18 views

Sort selected columns by row

In Numbers, how is it possible to sort selected columns by a row? In the following example I want to sort the columns B, C and D by using the values in row 1. So far, I have only found the reverse ...
0
votes
0answers
21 views

Removing random gridlines in Numbers

How can I remove gridlines in Numbers? I have cleared all the gridlines and still can't remove from two rows. Is there a way to remove them?
0
votes
0answers
11 views

Maverick update to network and now Numbers documents on server locked

We updated Macs on network that are new enough to Mavericks. This included the server. Now all the Maverick computers are locked out of Numbers documents on server. The non Maverick computers can ...
0
votes
0answers
39 views

Copy Paste formula in Number 3.2

I have20 three-member groups with different individual measures. So, I have a sheet in which I have 60 (20*3) rows and number of columns )+ heading row). I also have another sheet in the same file ...
0
votes
0answers
36 views

How to display labels on bubble chart, Numbers (v3.2)

I want to display the label of each bubble on a bubble chart in numbers. How do you do this? I want either a truncated "description" or the 3-digit NAICS to be the label of the bubble. Here's an ...
0
votes
0answers
35 views

How to calculate total rental income of a property in Numbers?

I'm trying to calculate the total rental income of a property which increases in value over time. If I assume that the rent will always be 5% of the property value, and that the property is initially ...
0
votes
0answers
35 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
27 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 ...
0
votes
0answers
69 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 ...
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 ...
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 ...
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
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
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 ...
0
votes
0answers
50 views

Pages mail merger with numbers formulas in pages not working afterwards

I have the following setup for my invoices: Numbers file with client info, daily rate and days worked on a project. Pages file with mail merger fields. The merging works fine, and all infos are in ...
0
votes
0answers
113 views

How do I evaluate multiple equations in a single cell?

I have two equations in a Numbers spreadsheet: COUNTIF(PROMO,FALSE) COUNTIF(Purchases :: WL,FALSE) I need to merge these to satisfy one cell's value. Something similar to countif( A && B , ...