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
1answer
18 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
7 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
15 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
19 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
16 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
22 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
22 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
8 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
19 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
22 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
48 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
21 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
8 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
18 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
16 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
19 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
17 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
86 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
10 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
15 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
19 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
34 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
22 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
20 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
188 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
14 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
48 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
28 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
37 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
21 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
38 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
38 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
343 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
40 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 ...
0
votes
0answers
8 views

OSC Yosemite Numbers: conditional sum based on text of cell [duplicate]

I saw this answered for iWork a good few years ago but the work round doesn't now. I used this a lot in Excel and need it in Numbers. Help much appreciated. My query is exactly as the first time it ...
0
votes
0answers
35 views

Numbers: How to merge multiple sheets of products into one sheet, automatically update on change of data

What i'm trying to achieve is a database for food products split into three categories:- Frozen, Ambient and Chilled. Each category is on a separate sheet which is the data and in each category it ...
3
votes
2answers
101 views

The SUM function in Numbers 3.6.1 on my Mac OS X10.10.5 isn't calculating correctly. Why?

You can see in the attached screenshot that I have used the SUM function to add the values in column E. There are several "1" values (you can see one in cell E126) but the SUM always comes out at "0". ...
0
votes
0answers
108 views

Consolidating multiple sheets into one Numbers 3.6.1 OS X

I'm looking for a solution to automatically merge/consolidate the data from multiple sheets into one. I would like to stack the sheets on top of each other in it's own sheet. I would like to be able ...
1
vote
2answers
56 views

Conditional highlighting of booleans in Apple Numbers

Is it possible to do conditional highlighting of booleans in Apple Numbers? I want to highlight TRUE values one way, and FALSE values another, but booleans don't seem to be supported - only numbers, ...
1
vote
1answer
32 views

How to type floating point numbers in Apple Numbers in Persian?

When I want to insert a floating number in Apple Numbers 3.6.1 in OS X 10.10.5 while my primary preferred language in Language & Region is Persian(فارسی), the number is interpreted as a string ...
0
votes
0answers
39 views

Exporting from Numbers to CSV file

I am trying to export a spreadsheet out of Numbers into a CSV file. I know where and how to do this, however the file that is created is still generating a formatted table rather than having the ...
0
votes
1answer
185 views

Is there a formula or function for Numbers that returns the number of days or weeks for a given year

I have a budget table with cost per week, fortnight, month, quarter and year. Some expenses are charged quarterly and others monthly or weekly, but I want to know what the value of a cell is for the ...
0
votes
0answers
44 views

How to copy one cell's value to other cells of the same date in Numbers?

Given one spreadsheet in Numbers as the following. Column A is datetime, and column B is the value. For each date (ex, 2015-12-01), there is just one cell with non-empty value on 05AM. Ex, there are ...