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
1answer
2k views

Creating an adding and subtracting formula in Numbers

I'm creating a financial spreadsheet and need to ask the spreadsheet to calculate the new balance after subtracting and adding sums. For example, I want to calculate the running total in E column. I ...
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?
2
votes
1answer
2k views

Greyed out Hide Column command

In iWork Numbers, why is the command Hide Column greyed out? What format do I have set up that does not allow me to hide that specific column? I have un-merged all the cells.
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 ...
3
votes
3answers
5k views

Auto-Populate A Pop-Up Menu in Numbers 3.5

I'm trying to steer clear of Excel, despite my sister's nagging, and I've done pretty well to create a Quote and Invoice workbook in Numbers. The problem I am having is working out how to ...
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
2answers
61 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
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 ...
2
votes
6answers
3k 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 ...
1
vote
2answers
1k views

How do I insert a row into numbers, in just one column

How do I insert a row in one column only. By moving the current data down and inserting a row above it. I don't want to insert a row across the entire spreadsheet - just that column.
3
votes
2answers
7k views

How to display zero value as blank cell in mac numbers 3.1

How do I display zero value as blank cell in mac numbers 3.1 yet maintain a formula. I want a running balance column that only shows balance to the line of the last entry like a checkbook register. ...
3
votes
1answer
2k 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?
0
votes
2answers
2k views

Set Print Range in Numbers.app

Is there any way to set a print range in Apple Numbers.app spreadsheets, to print just a subset of cells rather than entire document?
2
votes
8answers
10k views

Is it possible to remove cell borders from Numbers?

I imported an Excel spreadsheet that contained a few cells with black lines as their border. Is it possible to remove these outlines through Numbers (iOS)? I have tried copying and pasting, the ...
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
29 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
2answers
1k views

Apple Numbers: how to change a date format to a number format

In Apple Numbers the app can work out the number of days between dates, but then if I times this by a number (ie, a %interest rate and an amount of money) Numbers insists that the answer is a number ...
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
28 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
7answers
4k views

Remove hyperlink formatting from address

I have created a Numbers spreadsheet containing a set of data including email addresses. Some of these addresses appear as hyperlinks, and I can't seem to edit or change them. Every time I try to ...
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 ...
1
vote
1answer
275 views

Charts from numbers not dynamically updating in Pages/Keynote

I have the latest (5/2015) Pages, Numbers, and Keynote on Yosemite. I created a chart in numbers and then copied it to Pages or Keynote. I then want to be able to change the data in Numbers and see ...
3
votes
1answer
25 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)
1
vote
1answer
28 views

Numbers Between Formula

IF(AND(B13≤74,B13≥75,B13>90),"0","3, 5") I'm trying to generate an if statement that outputs either 0 if under 74 or under 3 between 75 - 89 and 5 if over 90. I have been trying the above however ...
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
99 views

Numbers for Mac : Sumifs formula

I have a problem with my sumifs formula. I am trying to get: I want to achiev this: Sum C5:C7 from all lists that contain word Teletnik and in the first list Formular you would get the result in C4 ...
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
1answer
315 views

Numbers SUMIF by dates within current week?

I have a table like this: Which basically contains jobs I've done, the dates I did those jobs and how much that job made me. I'd like to find out how much money I've made this week (current date ...
0
votes
2answers
27 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, ...
3
votes
3answers
8k views

How to change the colors of individual bars in Numbers 3.2

How do I change the colors of individual bars, in a bar chart of in Apple's Numbers 3.2.x
2
votes
4answers
2k views

Connecting MySQL DB to Apple iWork Numbers?

I'd like to visualize some data from a MySQL database using a Mac, but it hasn't been easy finding a solution to this. I understand Excel has DB connectivity, but currently I only have Apple Numbers. ...
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
90 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 ...
1
vote
3answers
3k views

How do I delete one of my custom templates in Numbers - OS 10.10.1

I would like to delete one of my custom templates I made in Numbers - in previous OS versions you went to Library>iWork>Numbers>Templates and just trash it - but, since I updated to Yosemite - I only ...