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

Two value-based axis for chart in Numbers 3.5

I am trying to achieve a chart in Numbers 3.5 where both axis scale linearly. Right now, my chart looks like this: Obviously, I want the x-axis to scale because the 100.000 bytes message is MUCH ...
0
votes
1answer
7 views

How do I do a COUNTIF on another table column in Numbers?

I am on 2014 Macbook Pro running Mavericks. I have two tables. In table 1, I have a cell that should store the number of cells in column A of table 2. In the same table 1, I have a different cell ...
1
vote
1answer
31 views

Open new Numbers document in older Numbers

I have a Numbers (v3.5) file from a Yosemite install. I have since abandoned Yosemite (here is why WindowServer high CPU on Yosemite). Now I cannot open this file in Mavericks' Numbers (v2.3) app. I ...
5
votes
2answers
3k views

Link information between spreadsheets in iPad using Numbers

Could you link to data in one spreadsheet from another using Numbers for iPad?
4
votes
1answer
999 views

Numbers v3.1: Automatically link URLs in spreadsheet?

I've inherited a spreadsheet that has a loooong column (thousands) of URLs, all unclickable. I'd like to make them clickable. I have tried the following: Highlighting the column. Select column, ...
0
votes
0answers
11 views

Data dependent multiplication of sheets

I have one number document with three sheets. They look like this: DataSheet: Name,Sex,Year,Val1,Val2,Val3... FactorSheets: Name,Val1,Val2,Val3... I want to create a fourth sheet (ResultS) that ...
0
votes
0answers
40 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 ...
0
votes
0answers
21 views

copy / paste and remove spaces in Numbers

When I copy non-sequential items in a column (using the Numbers spreadsheet on an iMac), then paste them into another column, is there a way to automatically take out the spaces (or vacant cells) as ...
3
votes
0answers
2k views

How do I create a Pivot Table in Numbers 3.2?

I'm new to Numbers and currently using Numbers 3.2. I already have an idea of how to use SUMIFS to create Pivot Tables in Numbers, but I'm still looking for a better way to generate the column & ...
2
votes
3answers
16k views

How to import a spreadsheet into Numbers from an email attachment?

I want to know how to open a spreadheet email attachement in the Numbers app on the iPad. Here are the steps I have taken with no luck: On the iPad I open my email. I see a spreadsheet attachment. ...
0
votes
2answers
1k views

I've just updated my Mac to Yosemite and now I can't open a .numbers file

I have just updated my Mac to Yosemite and after that when I try to open .numbers file, I couldn't, and it gives me this message "edit 1.numbers can't be opened". I do not know why and I really need ...
0
votes
2answers
38 views

Numbers V3: If cell contains a value, convert cell value to X

I have a spreadsheet which contains a mixture of text strings and empty cells. I'm looking for a formula to replace the value of all non-empty cells with a single character 'x', while leaving empty ...
0
votes
1answer
101 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
48 views

Applescript read specific data out of iWork Numbers

I am trying to get data out of a table in Numbers. I have an index number, I need to get the name associated with it in applescript. (Eventually I need to set names of files with one of columns of ...
-1
votes
0answers
51 views

Error message: “The application ”Numbers“ is not open anymore.” when trying to open of force quite Numbers

MacBook Pro (15-inch, Late 2008) OS 10.10.1 iWork ‘08 Numbers 1.0.1 Error message: "The application "Numbers" is not open anymore."
4
votes
3answers
6k views

How to gracefully import CSV files into Numbers.app v3?

I have a process, which has worked faithfully for years in Numbers '09, whereby I download my Bank account data in CSV format, then drag that data directly into my Numbers sheet (after creating an ...
2
votes
3answers
83 views

How to open numbers spreadsheet in 2 separate windows

I often find it useful to have two tabs of one spreadsheet open in separate windows. In Excel this is easy (Windows/New Window). Is there any way to achieve this in Numbers (as of Version 3.5)? For ...
1
vote
1answer
48 views

Sort selected columns by row

In Numbers, how is it possible to sort selected columns by a row? In the following example I want to sort the columns B, C and D by using the values in row 1. So far, I have only found the reverse ...
1
vote
1answer
36 views

How to visualize calendar dates (in Keynote? Or Numbers?)

I am having trouble visualizing dates in a presentation. This image is a good example of what I'm hoping to have, but I would like a way to make the slide from a table of dates (rather than making ...
2
votes
0answers
98 views

Changing the open with settings in 10.10.1

I am looking for a way to edit the open with settings in 10.10.1, i have looked through older questions and have attempted to rename the launch services plist and have gotten no where. I have looked ...
1
vote
0answers
40 views

How can I link data from Numbers to a Pages document?

I'd like to have all my client invoices in a Numbers document, including invoice number, service period, daily rates,... and generate a invoice from that with a template I have created in Pages. How ...
0
votes
0answers
36 views

How to highlight or filter for duplicate values in a column in a Numbers spreadsheet?

I have a Numbers spreadsheet with a few thousand rows containing a column with phone numbers. As part of a cleanup of the sheet, I need to identify rows where the phone number has been duplicated so ...
5
votes
3answers
9k views

How can I do text-to-columns in Numbers?

I've got a column where each cell in the column contains two different pieces of data separated by a known delimiter ", ". How can I split each cell in this column around the delimiter? Given: ...
0
votes
1answer
35 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?
0
votes
0answers
17 views

Apple numbers '08: extending a formula

how can i get a formula to apply to every cell in a column (i.e., i want to subtract a number I just entered in one cell from a total I have in a previous cell and I want to do it each subsequent cell ...
0
votes
1answer
33 views

How to hide columns

The old version of numbers had a "hide column or row" feature. I could right click a column and the "hide" option appeared on the same window as "add/delete" and "merge." However with the 3.2 update I ...
0
votes
1answer
180 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 ...
0
votes
0answers
29 views

Apple Numbers 3: how to set a background-color for the whole paper?

I want to set the backgroundcolor (in Numbers 3) of the paper to specific color. I tried to fill the cells but it does not work. I tried to to do it with an rectangle but it does not work. See the ...
2
votes
1answer
2k views

Keyboard shortcut to delete row in Numbers

I can add rows conveniently using Option+Shift+Up Arrow (insert above) or Option+Shift+Down Arrow(insert below). Is there a keyboard shortcut to delete the current row?
0
votes
1answer
31 views

Mastering Categories in Numbers

I have a budget with a Column for "Categories" and for "Amount". Within the Column for categories, as one might expect, is a category for "Groceries". Groceries is column "C" and Amount is column D. ...
0
votes
1answer
96 views

How can I add custom error bars to a graph in Numbers

I am using numbers 2014 - above is a screenshot that should explain it.
1
vote
1answer
41 views

Numbers: How do I write between in an IF statement?

I can't get the following formula to work in Apple's Numbers.app. I need the second IF to be BETWEEN 33.3% AND 66.6%. This is what I have tried but it does not work: ...
0
votes
0answers
13 views

Numbers Full Screen on iPhone

I have recently got an iPhone. I transferred some of my Numbers spreadsheets. I expected these to be smaller than on iPad and Mac, but 20% of the screen is used for menu and list of sheeets (even on a ...
5
votes
1answer
145 views

Can I use Javascript to write a custom function for Numbers?

It's always annoyed me that I can't write a custom function for Numbers. It would make the spreadsheet so much more useful to me. In Google Apps spreadsheets you can do it, using Javascript. In ...
0
votes
0answers
41 views

Numbers for Mac: Force line chart to show axis at point (0, 0)

Look at this line chart. I wonder if its possible to force Numbers to show Y=0, for example, without needing to add a data entry point to make it happen. - Is it possible?
1
vote
2answers
842 views

Copy static cell value in Numbers

In numbers I have a table that contains some configuration values, I reference these in formulas but when I copy and paste the cells using the configuration values it breaks as it increments the cell ...
1
vote
1answer
88 views

Disabling warnings in iWork

Is there any way of disabling the warning popups in the current versions of Numbers, Pages and Keynote that popup when files are opened? For example: They are pretty useless warnings, in the sense ...
2
votes
1answer
737 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
0answers
100 views

How to insert a “pop-out image thumbnail” into a cell in Numbers?

I have a Numbers document where I would like to insert images into each cell in one of the columns, in one of my data tables. The images are quite large, so I would like to insert the images as a ...
1
vote
1answer
211 views

How to export Contacts version 9.0 data or .abbu file to .csv or other usable spreadsheet format

In the newest Apple Contacts version 9.0, how do you export all contacts or an .abbu file to a .csv file or other usable spreadsheet format? Dragging and dropping to Numbers does not work. Exporting ...
0
votes
1answer
131 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 ...
1
vote
1answer
16 views

How do I ignore units in Numbers?

I'm trying to do a simple calculation of 12 $/h multiplied by some other cells which represent days and hours. This is a simple multiplication on Google Spreadsheet, but in Numbers units are ...
1
vote
1answer
37 views

Deleting formula sources without destroying formula output, using Numbers for Mac

I would like to delete the source column for a formula in Numbers 3.2.2, without destroying values in the formula's output column. Specifically, I have a column of "Last, First" names, which I parse ...
2
votes
2answers
61 views

How do I preserve leading zeroes in Mac Excel?

I'm using Excel (v 14.4.4) on my Mac (10.9.5). I have opened a CSV file and I wish to save it to an .xls format (Excel 97-2004 Workbook). I have a column that has 6 digit numbers, some of which ...
1
vote
1answer
89 views

How can I sum values over a range of dates in Numbers?

I have the following formula SUMIFS(Daily Log::Income,Daily Log::A,"≥"&A3,Daily Log::A,"<"&A4) that I want to sum income over the associated month. As you can see, it's not doing what ...
0
votes
0answers
62 views

Locally created excel file does not open in Numbers

I have a local process which creates an excel file using the python library openpyxl. I am not able to open the file in Numbers. When I try I receive the simple message "filename can't be opened." I ...
0
votes
0answers
16 views

Writing Text in Cells in Numbers

How do I get the cell in numbers to expand but not merge with the other cell when the text is too long? Like, I want it to stay in the same line, unlike wrap where it'll just force the text down. ...
3
votes
1answer
230 views

How can I set Numbers to automatically copy a row of data from one sheet to another sheet?

I have a Numbers spreadsheet that has years worth of data in it. I'd like to call out specific rows in the spreadsheet and copy just those rows into a new sheet in the same file where I'd like the ...
0
votes
0answers
22 views

How can Apple iWork's number generate the empty data field?

The left is excel and the right is number. I would like to do the result like the left one, and how can I do it in number? Thanks.
6
votes
3answers
124 views

Is this possible to link the value to a database in Apple's iWork suite?

For example, I would like to make a Pages document that has a value that's linked to the company information and Keynotes and Numbers as well. So, when our company information changes, all the ...