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
6 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
16 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
6 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
64 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
5 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
12 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
16 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
15 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
11 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
21 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 ...
0
votes
0answers
21 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
18 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
23 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
71 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
11 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
29 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
11 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
26 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
28 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
25 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
16 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
21 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
29 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
33 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
337 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
30 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
27 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
83 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
votes
0answers
57 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
46 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
22 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
29 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
101 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
33 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 ...
0
votes
1answer
28 views

How do you remove a hyperlink from a cell in Numbers '08 version 1.0.3?

I have an address in a cell which is hyperlinked. I've also searched other posts on the topic and the selecting text and "right-clicking" does not bring up a menu with how to remove the link. I'd ...
-1
votes
1answer
209 views

How do I start rows with 0 (not 1) or not count header rows in Numbers?

I'm using the Numbers app to make a database or catalogue of stuff. For example, a list of all wines I'll try this year. And for each column, I'll have the name of the wine, a rating, the kind of ...
0
votes
1answer
86 views

Number 3.6.1: Cell value needs to be invisible, if the adjacent checkbox is checked

I'm not sure if this is the right forum, but here goes: I would like to keep the cell value (E8), if the adjacent cell (D8) is false (checkbox is not checked), else insert zero or null. I just keep ...
4
votes
2answers
114 views

How to get the month name in English using Numbers?

I'm using Apple Numbers v 3.6.1 on OS X 10.11 to automatically fill all the info I need to generate a receipt each month. "... " & MONTHNAME(MONTH(TODAY())) & " 1 − " & ...
0
votes
1answer
35 views

Repeating a formula for every row in Pages

I'm working on a simple formula in Pages where I have a table with 4 cells per row. Product Name, Purchase Price, Quantity and Total. I've created a simple formula that multiples Purchase Price ...
1
vote
1answer
24 views

Display point values on numbers graph

On an Excel graph, if I mouse-over a data point on the graph, the application shows me in a small pop-up window the exact X and Y data values of the point that I am mousing-over. Is there a way to do ...
0
votes
0answers
71 views

“Database” report writer for Numbers?

I serve on the Board of a Baroque Orchestra and have begun helping them get organized. The management of the orchestra does not have extensive technical skills so I've endeavored to help provide them ...
1
vote
2answers
90 views

Nested IF statement in Numbers

I am working on a table to tabulate mileage costs for my small business. I have 3 destinations I go to on a regular basis. I would like the address to automatically populate in the C cell if the ...
0
votes
1answer
26 views

Display blank on formula error

I'm making a timesheet. I have =sum (A2-A1) but I have more than one task a day and not all times are used. The cells without time in them result in an error with the formula. Which, in turn, choses ...
1
vote
1answer
21 views

Numbers Between Formula

IF(AND(B13≤74,B13≥75,B13>90),"0","3, 5") Hey guys im basically trying to generate a if statement that outputs either 0 if under 74 or under 3 between 75 - 89 and 5 for over 90. I have been trying ...
0
votes
1answer
91 views

How to change y axis numbers in Numbers for mac to show as custom letters or words?

I'm new to Numbers and now creating my first chart. I tried to find what I was looking for on google but couldn't find anything. What I would like to do is change the numbers in the Y axis to show has ...
0
votes
0answers
60 views

Numbers for Mac : Sumifs formula

I have problem with my sumifs formula. I am trying to get enter image description here. I want to achiev this: Sum C5:C7 from all lists that contain word Teletnik and in the first list Formular you ...
2
votes
1answer
75 views

Round displayed value in Numbers for iOS to 2 decimals

Say I have the value 2.3638383 in a cell in Numbers for iOS (iPhone). Can I format the numbers so only 2 decimal places are shown (rounded to nearest decimal)? So 2.3638383 would be displayed as 2.36? ...
0
votes
2answers
68 views

Reinstalling Numbers on Mac OS X

Numbers was installed with a different Apple ID to mine (my bosses), so it won't let me update it (when it prompts for credentials, you can't overwrite the user name). I therefore need to reinstall it ...
0
votes
0answers
24 views

How can I change the behavior of alt-return and return in Numbers 3.6?

According to https://discussions.apple.com/thread/2448952?start=0&tstart=0, there's a box at the bottom of the table inspector: There are at least two ways to make multiple lines in a cell. ...