Questions tagged [numbers]

A spreadsheet application developed by Apple as part of its iWork suite availble for iOS, macOS and cross-platform via iCloud. It is the Apple alternative to Microsoft Office Excel.

Filter by
Sorted by
Tagged with
0
votes
1answer
484 views

Numbers: How to make a sum product of 2 columns numbers of which only those with checkboxes checked in a 3rd column respectively?

Say, sumproduct(A, B)=a1*b1 + a2*b2 + a3*b3, now I have many columns C, D,..., e.g. c1 checked, c2 unchecked, c3 checked; d1 unchecked, d2 checked, d3 checked; Now I need a formulae which I want to ...
0
votes
2answers
101 views

How can one jump to a specific line in Numbers?

In Numbers on a MacBook Pro Early 2013, how can one jump to a specific line, such as line 4223860. The data is actually csv formatted, and I have no clue what is inside that line. Any help is very ...
6
votes
1answer
478 views

is there a way to disable update notifications in iWork apps (Pages, Keynote, Numbers)?

Even with App Store Automatic Updates set to OFF, all of the iWork apps pop up a modal dialog box on startup to inform you there is an update. Is there a way to disable this behavior (in El Capitan)?
5
votes
1answer
12k views

Locking cells in numbers

Is there an easy way to lock individual cells or a group of cells in Numbers to prevent the data in the cell from being changed?
1
vote
1answer
2k views

Hide sheets in Numbers?

Is there any way to hide sheets in Numbers? (like in Excel) I have tried everything other than delete, since I may need to refer back to them.
0
votes
1answer
2k views

Keynote, numbers and pages not available on El Capitan after reinstalling

I had installed Windows on my MacBook Air after wiping its HDD and then decided to have OS X reinstalled. One thing I noticed is that the office software that had previously showed up in the dock wasn'...
1
vote
1answer
4k views

macOS Sierra / Numbers 4.0: Problem with saving on a Synology via AFP

I updated my Mac to 10.12 Sierra and updated Pages, Numbers and Keynote afterwards to the latest versions. So far so good, everything running normal. But unfortunately saving a Numbers file via AFP ...
1
vote
2answers
333 views

Open AppleWorks spreadsheets in Mac OS X when Numbers won't work

I have a number of old AppleWorks spreadsheets that I'm trying to open. I've tried a number of solutions that I've found while searching for an answer (below), but none of them really get me to where ...
1
vote
1answer
67 views

How to find all iWork documents which are not yet converted to iWork'13?

When opening documents in iWork'13, the documents are converted and may wind up looking different if they were created in iWork'09 (see Apple support article ”Working with iWork'09 files"). Documents ...
2
votes
1answer
842 views

Mass conversion of .numbers files to .csv

I have a lot of files with a .numbers file extension, and I need to convert them to .csv, so I can more easily work with the data. There are probably about 1000 of them, so opening them in numbers and ...
0
votes
1answer
21 views

Displaying numbers with the right sign

I have an odd question: how can I persuade Numbers to show the signs of a series of numbers which may be either positive or negative? The negative sign is a default setting, but there appears to be no ...
2
votes
1answer
45 views

Format values in text cell

I have a chart with two percentage columns (min, max), and a third which is supposed to show the min-max range in absolute values. I use the formula =A2*60&" - "&B2*60 in cell C2. The expected ...
0
votes
1answer
473 views

Numbers: how to search only within a selected range?

I have a very big table, and searching for a string can take a few seconds. However, I only want to search in a particular column. Even when a column is selected, Numbers searches the entire table. ...
0
votes
0answers
36 views

Copy contents of Numbers file on OS X El Capitan

When I ran OS X Yosemite, I worked on a .numbers file. Just recently, I needed to acces the contents of that file. However, the file opens only in Preview, and the Numbers app appears to be a paid one....
0
votes
2answers
4k 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? ...
1
vote
1answer
259 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 ...
4
votes
1answer
3k 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 (and ideally also highlight) each point with the corresponding entries ...
3
votes
1answer
3k 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 will note ...
0
votes
1answer
6k views

How to see page breaks in Numbers version 3.x

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
54 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 ...
2
votes
0answers
236 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 ...
2
votes
1answer
768 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
33 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
228 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
2answers
1k 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, ...
9
votes
3answers
19k 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
1answer
61 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 ...
4
votes
2answers
4k 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
1answer
102 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 ...
2
votes
0answers
447 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....
1
vote
1answer
61 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
2answers
2k 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
49 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
820 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 ...
1
vote
2answers
62 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 ...
1
vote
1answer
438 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
45 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
66 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 ...
0
votes
1answer
355 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
1k 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.
2
votes
1answer
5k 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 remains ...
2
votes
2answers
1k 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". ...
3
votes
2answers
1k 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, ...
2
votes
1answer
454 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 ...
1
vote
1answer
7k 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
1answer
964 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 ...
3
votes
3answers
45k 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
346 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
1k 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 − " & MONTHNAME(MONTH(...
0
votes
1answer
83 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 with ...