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

learn more… | top users | synonyms

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 ...
0
votes
2answers
319 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 ...
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
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
1answer
8 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
44 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
203 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
365 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
25 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
63 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
177 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
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??
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.
0
votes
1answer
70 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 ...
0
votes
1answer
175 views

Style text in Numbers formula

I have a numbers formula used in invoice generation: ="Invoice terms: "&CONCATENATE(Terms)&", please pay by ..." Which returns: Invoice terms: 14 days, please pay by ... Is there a ...
3
votes
0answers
219 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
25 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
60 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
35 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
119 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
24 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
131 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
28 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
22 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
67 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
86 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
275 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
17 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
10 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
27 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
25 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
32 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
30 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
26 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
68 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
27 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 ...
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
26 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
26 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
38 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
49 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
109 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 , ...