A spreadsheet application developed by Apple as part of its iWork suite. The iWork equivalent of Microsoft Office Excel.

learn more… | top users | synonyms

2
votes
0answers
534 views

batch convert iWork 08 files to new version on Yosemite

TL;DR Short version: I have a bunch of files that were created with iWork 08. Is there a way, maybe using AppleScript or Automator, to convert them to the new format (Pages 5.5, Numbers 3.5) without ...
2
votes
1answer
98 views

Why does CMD+1 work if using my top row numkeys, but not my right-side NumPad? Mac

I use a lot of keyboard shortcuts, like CMDkey + 1. However, that 1 has to be from my top row numeric keys. If I try using CMDkey plus a number from the NumPad on the right side of my keyboard - this ...
1
vote
1answer
764 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.
0
votes
0answers
170 views

Template for solving systems of equations in Numbers?

Can anyone direct me to a template, method, or example for solving systems of equations with Numbers? Excel supports this with its SOLVE facility, but I see nothing obviously like that in Numbers. ...
0
votes
1answer
324 views

Cannot update Numbers document on iPad

I have a Mac, running OS X 10.10.2 and an iPad Mini running iOS 8.1 Both have the latest version of Numbers. I have a spreadsheet, which I update roughly monthly on the Mac. I have transferred this ...
1
vote
2answers
1k views

Linking between tables in Numbers

I have a table in numbers, and I want a cell to equal the value of a cell in a different table. Following the advice of this Apple discussion, I tried =Units Sold::B2 , with Units Sold being the ...
1
vote
1answer
42 views

Increase precision in numbers

In Numbers, when I enter 0.981, it gets automatically formatted as 1. How can I increase the precision? When I double click on the cell I can see 0.981 but as soon as I deselect it, it goes back to ...
0
votes
1answer
773 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
299 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 ...
2
votes
1answer
641 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 ...
0
votes
2answers
2k 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
2answers
180 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
599 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 ...
2
votes
4answers
522 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
978 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 ...
3
votes
0answers
387 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
354 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 ...
2
votes
2answers
4k 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
2answers
1k 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
1answer
77 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 ...
0
votes
1answer
496 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
539 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. ...
2
votes
1answer
2k 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: ...
1
vote
1answer
281 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
1answer
3k 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.
2
votes
1answer
601 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 ...
0
votes
1answer
975 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 ...
0
votes
2answers
7k 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 ...
2
votes
2answers
4k 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
2answers
986 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
29 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
687 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 ...
5
votes
1answer
506 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 ...
2
votes
2answers
980 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 ...
2
votes
1answer
1k 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
1answer
54 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
1k 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 ...
1
vote
0answers
59 views

How to get long decimals from functions in Numbers?

I am using Numbers on OS X to help me with a GIS project; I have created a .CSV file that describes a polygon in terms of the distance and bearing between any two consecutive vertices. Using the ...
1
vote
1answer
346 views

Concatenate & VLOOKUP

In Numbers, I'm trying to enhance a Concatenated formula of multiple VLOOKUP results. I'm currently producing a result of three concatenated answers (each a specific VLOOKUP formula). I would like to ...
2
votes
2answers
5k 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
1
vote
0answers
547 views

App Store Purchase Update gives “An error has occurred” messages for Keynote and Numbers

I am trying to install Keynote, Pages, and Numbers from my App Store account using my Apple ID and password. Pages has installed properly and works. Numbers and Keynote both failed and do not open. ...
0
votes
1answer
70 views

Xls to csv - Numbers creates multiple csv files for some reason

I have a small xls file which 200Kb of size. When I export it to csv format, Numbers creates multiple csv files. How do I make it create a single one?
1
vote
1answer
3k views

How to sort column by date in Numbers?

I've my column in format dd/mm/yyyy and I would like to sort them by date. But I can't find any way of sorting the column by date. If I Sort Ascending, it doesn't recognise that the rows have the date ...
0
votes
1answer
541 views

iWork'08 sumifs equivalent in Numbers

Does iWork '08 have a sumifs type command? If not, how can I sum on multiple conditions? Essentially how do I fo the following: =sumifs(A$2:A$20,B$2:B$20,"<10",C$2:C$20,"female) many thanks!
0
votes
1answer
757 views

Conditional IF DATE function

I am working to create a function that keeps the data in a cell dynamic until the date is beyond that of the date column. In other words, there is a column of dates, i.e. 9/5 9/6 9/7... and the other ...
0
votes
4answers
3k 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
98 views

Can't open Numbers, but can open Numbers.app/Contents/MacOS/Numbers

Okay, this is weird. I can't open Numbers by trying to open the .app file, but I can open it by drilling down into the app and opening Numbers.app/Contents/MacOS/Numbers via terminal. Anyone have ...
2
votes
0answers
1k views

How to use an array as a condition in a COUNTIFS or SUMIFS formula

This question could be tricky to follow so I'll split it out with examples Given I have this table of overpriced fruits; Item Price Apple £0.80 Peach £1 Pear £1 ...
1
vote
1answer
363 views

Numbers app: how to change x axis position + change chart's line width

I have a regular linear graph and have y values running from negative to positive, enabling x axis shows the line at the bottom of the graph. How is it possible to set it to show at zero, i.e. running ...
0
votes
1answer
65 views

Using last column in Numbers

I would like to subtract the last column of a specific row. Since the number of columns is always changing, I need to get it dynamically. I figured there is a function that gives you the number of ...