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
7 views

Sync Numbers templates between OS X Yosemite and iOS 8

I want to create a template spreadsheet in Numbers for OS X Yosemite and have this template appear in Numbers in iOS 8. I've followed the advice in this page and have created a template on my Mac. ...
0
votes
0answers
7 views

Numbers: is it possible to add multiple select elements?

I'm working on template in Numbers. Some cell in template can have only specific values from code lists, so I decided to add pop-up format for them. But some cell can have multiple values from code ...
0
votes
1answer
28 views

How do I separate multiple comma separated values in Numbers

So, one of the CSV files I'm using has lumped the address into one single cell, separated by commas. For example: 12 Fairy Tale Lane, Wonderland, Oz, Neverland I need to separate these into Address ...
0
votes
1answer
37 views

How do you formulate Microsoft Excel “if” statement equivalent in Numbers?

The syntax of a simple Excel if statement is: =IF(a1="a",b2,"") This places the contents of cell b2 in the current cell if cell a1 contains the character "a". Otherwise the current cell is cleared. ...
0
votes
1answer
16 views

Apple Numbers program, weird thing with unix time code formula

Hi I have applied the unix time code formula =(((A1/60)/60)/24)+DATE(1970,1,1)+(-5/24) And it works! But the result I get on my column only shows the date and not the time. Does anyone know how to ...
0
votes
0answers
11 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
33 views

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

In Pages and Numbers (I guess Keynote too) for iCloud if you share a document and then send the link to other people you get real-time collaboration between the contributors as they edit the document ...
0
votes
0answers
12 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
18 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
11 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
17 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
34 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
23 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
32 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
73 views

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

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? Numbers 3.5.2 MacBook Air ...
0
votes
0answers
42 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
24 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
24 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
38 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
38 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
58 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
65 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 ...
2
votes
1answer
202 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
21 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
239 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
58 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
72 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
52 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
83 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
159 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
27 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
138 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
44 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
215 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
18 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
406 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
57 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
68 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
215 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
212 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
195 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
221 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
98 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
875 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
147 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
269 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
31 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
83 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
64 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
131 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. ...