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

Problem with Numbers, stopped working!

The Numbers Icon on my IPad suddenly greyed out. When I selected it it went in to waiting state. Eventually it tried to load but gets to a certain stage of loading and hangs. I have some important ...
1
vote
0answers
8 views

Do Pages and Numbers for Mac/iOS offer real-time collaboration on shared documents like Pages and Numbers for iCloud do?

In Pages and Numbers (I guess Keynote too) for iCloud if you share a document and then share it with other people you get real-time collaboration between the contributors as they edit the document and ...
0
votes
0answers
8 views

Numbers: Replace URL with image

Is there any way to replace a text field cell which contains a URL with the image which that URL points to? It would make my life so much easier.
1
vote
1answer
13 views

Get cell value by address string in Numbers

In Numbers 3.5.2 I manage to get a cell address sting (I compute it based on some data). Now when I have it, how can I get the value behind that address without copying the result of my function to ...
0
votes
0answers
9 views

Numbers spreadsheet - list of worksheets on right side

How can I get a menu of the worksheets on the right side of a Numbers workbook? In an older Numbers version, the default was to have a list on the right so you could scroll down to find the worksheet ...
0
votes
0answers
12 views

When does Numbers sync spreadsheets?

In Numbers, connected to wifi (good bandwidth), after modifying a spreadsheet I go back to "Spreadsheets". Then I wait for the Arrow ↑ to appear, as it indicates that Numbers is syncing with iCloud. ...
0
votes
0answers
18 views

Cross-reference data from different tables in Apple Numbers

I have a table with exchange rates, and a table with business costs made in various currencies (Yen and USD). I have a column that lists the exchange rate on that day to make the calculation back to ...
1
vote
2answers
19 views

Numbers default colors

The default grays in Numbers don't suit my needs (the gray is too dark). Is there any way to adjust this pallette? I always find myself diving into the colors palette but this gets time consuming and ...
2
votes
0answers
27 views

Looking for a grandma-safe way to create two-fold greeting cards

My Mom (+ 70) longs for the day when her Windows Paint Shop program would walk her through creating a 2-fold 8 1/2 x 11 card. She could assemble the card one page at a time and not think about what ...
0
votes
0answers
56 views

Why can't I edit a Numbers spreadsheet I created?

Numbers 3.5.2 Macbook Air I have a small spreadsheet I created in Numbers. But when I click in the spreadsheet, there is no cursor and I can't edit anything. Could anyone tell me why this might be? ...
0
votes
0answers
11 views

create a pie in numbers with data and value

So, I have this data, I'd like to show 200 instead of 81% I can't believe I haven't yet found a way to do so. any help is appreciated ciao
0
votes
0answers
32 views

How to use Numbers to generate pdf on a web server and then email it out?

I have an issue. My client loved the report I generated using Numbers on Mavericks OS X. The bad news is that the data is being processed on a ubuntu machine running python and django. I want to ...
0
votes
0answers
22 views

Export specefic iTunes music information to spreadsheet?

Ok so I really need help with this one. I'm doing a school project and I need to be able to chart the Date Added, Date Last Played, and # of plays. Does anyone know of a way to export/copy/retrieve ...
0
votes
1answer
23 views

Numbers - date cell set to last day of the month

I have a Numbers sheet that I use to forecast the monthly interest payments on my mortgage and it's working well. The only issue is that the date cells auto-sets to the first day of the month. Is ...
0
votes
1answer
27 views

Numbers: VALUE function does not recognize empty string

I am using Apple Numbers and find it frustrating that cell arguments containing empty text (and sometimes contain numbers from other sheets) are not converted to a number of value 0, when referenced ...
0
votes
1answer
30 views

How to convert to millions in Mac:Numbers?

I understand in Microsoft Excel you would use the format string $#.##,," M" so that 12,271,359 would appear as 12.27M I am alittle confused with the Numbers app on Mac (the excel equivalent) and I ...
0
votes
0answers
46 views

Numbers.app - How to add up items from multiple sheets and popup lists

Based on the "Personal Budget" template: I want to use the Personal Budget template and modify it to my needs — I want a total sheet that will add up information from 12 data sheets (for each month). ...
0
votes
1answer
54 views

Creating an adding and subtracting formula in Numbers

How do I enter a sum formula in Numbers for Mac? 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 ...
1
vote
1answer
132 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
20 views

How to mark some columns as ignored for calculations Numbers?

I'm creating a template on Numbers and I would like to know if there is a way for the formula to ignore, or skip over some cells or even entire columns. I need these columns for some calculations, but ...
2
votes
0answers
205 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
51 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
48 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
43 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
60 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
110 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
26 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
112 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
39 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
157 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
0answers
16 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
1answer
316 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
49 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 ...
0
votes
2answers
66 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
178 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
3answers
174 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
146 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
206 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
86 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
1answer
648 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
0answers
130 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 ...
0
votes
2answers
202 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
27 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
74 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
0answers
55 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 ...
0
votes
1answer
90 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. ...
1
vote
1answer
281 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
18 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 ...
1
vote
0answers
97 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?
0
votes
1answer
595 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.