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

learn more… | top users | synonyms

0
votes
0answers
5 views

What is the Numbers equivalent of Excel's “Solver”?

I'm a former Excel user and particularly of the "Solver Routine" I have found nothing of that nature in Numbers. Also is there an integration routine to find the area under curves?
0
votes
0answers
7 views

Scatter Plots in Numbers

Using Chart in Numbers how can I reverse the plot values on the X axis of a scatter plot? I have searched Numbers Help to no avail.
0
votes
0answers
4 views

Error when using Numbers CONVERT function. Invalid unit?

Using Numbers 3.6.2 I'm trying to convert some numbers (with Numbers) with the use of the CONVERT function, like so: Working: CONVERT(1, "m", "cm") Not Working: CONVERT(1, "d", "c") CONVERT(1, "...
0
votes
2answers
13 views

Mac Numbers - How do I add up cells containing data (text) per column

In my Mac Numbers Spreadsheet, I have got a column containing a product title. I would like to add up the cells containing a title at the bottom on my spreadsheet. What formula do I use for that? ...
0
votes
0answers
8 views

Numbers: How Can I Make Rows and Columns Smaller than 9 Points?

I am making a grid-like diagram (for table seats at a party) using a Numbers table. Some cells are considerable wide and hold the names of the guests. But I need to make some of the rows and columns ...
0
votes
1answer
10 views

Numbers: Count number of payments, SumIf, CountIf, Concatenate Date, change data types

I am trying to create a spreadsheet that will figure out how much has been paid to date, from a list of payments in a separate row. I have tried many different options including using SumIF and ...
0
votes
0answers
7 views

How I label scatter plot points in Numbers?

I have a scatter plot in Numbers using one column of data from my table for X values and another for Y values and want to label each point with the corresponding entries in a third column. How do I do ...
0
votes
0answers
9 views

Numbers: thin the data going into a chart

I have a CSV file with just shy of 60,000 rows. It's a time series from a device. Numbers kind of chokes plotting a chart, even though I only want 2 columns from it. It makes one, but it beachballs ...
0
votes
0answers
27 views

How do I set the number of decimals in a Numbers cell using AppleScript?

I can set the format of a cell in a Numbers spreadsheet using: tell application "Numbers" activate tell document 1 tell active sheet set the selectedTable to ¬ ...
1
vote
1answer
25 views

Numbers: checking if cell with specific text exists

Prerequisites I have some tables with cells like so: Also, I have some more tables like so: Objective Note the YES and NO. in the Included column in the Example Requirements table. You ...
0
votes
0answers
10 views

Numbers graph how to get series in front of grid lines

I am making a graph in Numbers with logarithmic y-axis. I would like to have grid lines at 0.01, 0.1, 1 and 10. However, if I use the "main grid lines" function (in the tab "axis") it won't draw a ...
0
votes
1answer
29 views

Numbers version 3.6.2

In my old version of Numbers, I could see the page break (both at the bottom of the page, and on the side) so I would know when I needed to add a row or column. I can't seem to be able to see the page ...
1
vote
0answers
17 views

Numbers formula for calculating *part-time* workdays per month?

I want to calculate the total number of monthly workdays for part-timers. Example, I need to calculate the full number of workdays in a month for a 3.5 day workweek, running from Tuesday to half ...
0
votes
0answers
27 views

Numbers, wish to convert Excel to Vcard to import to Contacts

I have a 250+ contact Excel file that I wish to, instead of doing it by hand, one row at a time, batch-convert into iCloud Contacts -ready Vcards. Anyone have any idea how to do this? I've seen lots ...
1
vote
0answers
17 views

Using date as x-axis

I wish to create a chart where you can compare how many awards a bunch companies have won over time. After collecting the data I now want to plot it in Numbers. To simplify I have put together some ...
3
votes
1answer
24 views

How to get rid of default font (Helvetica Neue) in Numbers?

I am using Numbers '09. I defined (and saved within My Templates) a template of a very basic table format where all cells are formatted with Palatino: If I simply hit ⌘+Xwithin any selected cell, ...
0
votes
1answer
24 views

How do I save the Numbers document I'm working on?

Using Numbers 3.6.2, and would like to save document to finish later. Where do I save it? (Saving to PDF is permanent)
0
votes
1answer
10 views

Can Numbers use 8 hour long days when converting from days to hours?

Using Numbers 3.6.2, I am using cells formatted as "Duration" in days. I then have a SUM cell that sums all the durations and shows for example "64d" (Suppose in cell D1). I then do in a new cell (D2 ...
0
votes
0answers
22 views

Numbers Mac — Search for text in a cell based on a list or range

Here's what I'm trying to do: Basically, I want to automatically "categorize" items in Column A. I have a list of course titles in Column A. I want to search each cell to see if it contains a ...
0
votes
2answers
26 views

How do I fix a file that crashes Numbers?

A long time ago, I made a relatively simple Numbers document with some tables containing text and images. It lives in iCloud, and I can preview it using Quick Look. But now when I try to open it, ...
2
votes
2answers
90 views

How to fill down in Numbers without dragging?

I have a 20,000 line spreadsheet in Apple Numbers, and I need to fill a column with data. I don't want to sit there dragging down the fill handle for thousands of rows. How can I fill the whole ...
0
votes
0answers
34 views

How do I refresh a Apple Numbers spreadsheet to reload formulas?

I have a csv file that I import to Numbers. The file contains formulas such as =HYPERLINK("http://www.google.com","url to google") The problem is that it does not parse my formula but instead ...
0
votes
0answers
9 views

Is it possible to link a table between numbers and pages? [duplicate]

I'd like to know if I can create a table in numbers and link that table into pages so I can edit it in numbers and display it in pages with the rest of my document. Can this be done?
0
votes
0answers
20 views

Automatic email sent from numbers?

I'm currently working on a spread sheet using the APP Numbers. It would be useful if when a particular number is entered into a cell an email reminder is sent to a member of my team asking them to ...
0
votes
0answers
19 views

Cannot access to iCloud Numbers document, it shows alert dialog: “Versions of the spreadsheet are out of sync.”

My friend sent me the shared link of the iCloud Numbers spreadsheet. I could access the document without any problem via the browser for the first time. However, from the second time, the following ...
0
votes
1answer
20 views

How can I make two cells edit and display the same information in Numbers?

I would like two cells to contain the same information, if I modify one the other should modify also. I was using the Concatenate function to make "slave" cells that pull data from a "source" cell ...
0
votes
0answers
21 views

I need to link a cell in numbers to a Pages document. HELP

I would like to link a cell in a numbers document to a document in pages. I am creating a meal plan and want the recipe to pop up when clicking on the item. Any suggestions welcome, including whether ...
2
votes
1answer
89 views

Concatenate not working in Numbers

Sample numbers file B4 contains CONCATENATE(B2,B3) In the file above, I am getting syntax error on B4, despite the formula seems correct. Can anyone reproduce the problem? How can I solve it? ...
0
votes
0answers
11 views

Why does Cut in Numbers remove the cell formatting?

In Numbers 3.6.1 cutting [CMD+X] one or more cells not only clears the text, but removes the cell formatting too. Is there a setting to disable this behaviour? My only workaround is to Copy [CMD+C] ...
1
vote
0answers
18 views

Can I create a Range in numbers

I am using Javascript for Automation (JXA) with Numbers.app and I am wondering if I can instantiate a Range object, i.e. define which rows are concerned by the Range so that I can apply a function ...
0
votes
0answers
17 views

Auto sum of daily sales on a monthly range

Given a table of monthly sales where one row contains one sale but one date can have multiple rows as follow: Date Earnings 2016-04-12 USD 10.00 2016-04-12 USD 56.00 2016-04-12 ...
0
votes
1answer
21 views

How to calculate a date field in Numbers

I'm using a date field as a conditional element. If cell A1 which is date field is empty (no date has been entered yet), then leave the cell A2 blank. If there is a date entered into A1, run a ...
0
votes
0answers
12 views

Multiple condition or Regular Expression matching with conditional formatting in Numbers?

I'm useless without colors to help my brain, so Numbers' conditional formatting works well for me.. up to a point. I'm afraid I'm hitting up against Apple's wont fix complexity threshold, but oh well. ...
2
votes
0answers
38 views

Apple Numbers Query - Conditional Formatting

I am working on a numbers Spreadsheet that compares dates in cells. I am trying to create a condition where a date cell will turn green when the date is 3 months or more later than another date cell i....
0
votes
0answers
24 views

Summing data on multiple worksheets

I’ve recently run into a curious issue. I need to sum the values across multiple tables - basically to combine fields from the two pairs of tables I have, e.g. row 1 column 2 from table 1 with row 2 ...
1
vote
0answers
22 views

Make a line chart in Apple's Numbers using series of Numbers

I have a table in Apple's Numbers where I log a number every day: I want to do a line chart where every week is a line, so I can compare, every week, the trend for every day, week by week, but I ...
1
vote
1answer
26 views

Numbers: Force a calculation

My apologies for such a basic question, but I have searched for many hours to no avail. I have a very simple spreadsheet with two columns of data. In the third column, I write a formula such that ...
1
vote
1answer
229 views

Does Numbers on the iPad pro allow you to sketch with the Apple Pencil?

Using Apple Numbers a lot on my iPad iOS 9.2.1 Due to the limited availability, I haven't seen anyone sporting an Apple Pencil with an iPad Pro. Stores in my area have the iPad Pro but no Pencil. ...
0
votes
0answers
15 views

Two formulas in the same cell in Apple's Numbers

In Apple's Numbers, I have a table which calculates GAP between two values in two rows (red), I would like even to calculate gap between calculated values in the same cell (blue), is it possible?
0
votes
1answer
59 views

Getting the First Cell NOT Containing Certain Text in Numbers

I have a table in Numbers, and I'm trying to get the value of the first cell that contains the character …. In order to do so, I wanted to use MATCH(), but had no luck after I realized it could only ...
0
votes
0answers
14 views

automatic daily email with value of Apple Numbers spreadsheet cell

How can I use Automator (or some other tool) to email the value of a cell in an Apple Numbers spreadsheet every day?
1
vote
1answer
29 views

Text in cell with URL hidden

I'm trying to copy and paste a number (tracking number) from a UPS notification into a cell on Numbers. I want the number to appear with the link hidden but it keeps pasting the entire URL in the ...
0
votes
0answers
44 views

How can I prevent empty cells when hitting the delete button in excel 2013

I use data validation with a list of values (--Select--;1;2;3) for all cells in range "B7:E1006". The default value should be --select-- . With the vba code below: If someone hits the delete button ...
1
vote
1answer
36 views

Tan-1 on Numbers

Is there a way to do tan-1 using numbers on El Capitan to return an angle? I have two lengths 1.5 and 2.2 for example. I can do it on a scientific calculator but not on numbers.
0
votes
1answer
24 views

On Pages, inserting a graph from Numbers gives a black line at the bottom

Notice the black line at the bottom of the graph. When I add another graph after it (its inline), the line moves to the bottom of the next graph so that there is only ever 1 line.
1
vote
1answer
22 views

Can I create a formula to provide a value depending on when a timestamp falls in the day?

In column A, I have timestamp values. In a second column, I'd like to have a formula that would return words or strings like "early morning" or "Late afternoon", so that I may count and chart these ...
1
vote
0answers
41 views

Automate Safari form filling

I have a Numbers spreadsheet with lots of data (currently at 275 rows, 14 columns each). I need to submit this data to a web form, one row per form submission, each column going into a text box on ...
0
votes
1answer
44 views

iCloud numbers reference date/value from another table

I am trying to create a daily budget tracker with separate tables for each month, which I have created. I now want a front/first table to show: the balance as at today's date the amount spent today ...
3
votes
2answers
345 views

Numbers: Make numbers negative

In Numbers, how can I convert a number to negative. E.g. 200 233 186 Becomes -200 -233 -186 In Excel, you can use tools like Paste Special, but these don't exist in Numbers.
0
votes
1answer
47 views

In Numbers, how can I show a formula instead of the result?

I want selected cells to show the formula instead of the result of the formula, for example cells C4 and D4 here. If the cell is formatted as text before I enter the formula, then the formula ...