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
1answer
1k 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
8 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. ...
3
votes
2answers
4k 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 ...
0
votes
1answer
23 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.
0
votes
1answer
15 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
7 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
115 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 ...
-1
votes
0answers
9 views

Automatically enter dates in Daily Schedule after entering one date

How to enter one date on Daily Schedule in Numbers and the rest of the dates fill in automatically?
0
votes
0answers
17 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
753 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 ...
0
votes
1answer
210 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 ...
1
vote
1answer
39 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
608 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
31 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
1answer
38 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
49 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
13 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
20 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
25 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
50 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
28 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
14 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
60 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
15 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
118 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 ...
3
votes
2answers
2k views

Can't email Numbers 3.0 or Pages 5.0 documents via Google Mail (Gmail)

When I try to email a Numbers 3.0 or Pages 5.0 document via Google Mail, I receive the following error.
1
vote
1answer
48 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 ...
1
vote
0answers
22 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 ...
0
votes
1answer
119 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
253 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
27 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?
0
votes
0answers
20 views

User stylesheet / formatting for all osx apple apps

I'm increasingly spending lots of time tweaking text formats from one document to the next, updating styles, formats and generally improving them. Is there a way i can export styles from numbers, ...
5
votes
1answer
4k views

How to uninstall Numbers and Keynote on Mavericks?

I installed Pages version 5 on Mavericks via the "App Store". But the problem is Keynote and Numbers are installed also. I'm not interested in Keynote and definitely not in Numbers. I want to ...
1
vote
1answer
418 views

Converting a float to hours:minutes in Numbers

Probably this is a very easy thing to do, but as handicapped as I am using Apple's iWork applications, I just can't find it. I have made a calculation in Numbers which results for example in 14,25 or ...
0
votes
1answer
123 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
45 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!
3
votes
0answers
1k views

How Do i Pivot Table in Numbers 3.2?

I'm new to Numbers and currently using Numbers 3.2. I already got a clue of how to use SUMIFS to create Pivot Table in Numbers. But i'm still looking for a better answer of how to generate the ...
0
votes
1answer
31 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
0answers
80 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
50 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 ...
1
vote
0answers
124 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
0answers
22 views

How to update the formula in a column without deleting comments using Numbers for Mac

The question pretty much sums it up, I have a huge sheet with many calculated cells, conditional formatting and comments. In one column, lets say column K, I have a formula similar to this, ...
2
votes
0answers
139 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 ...
0
votes
1answer
26 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 ...
0
votes
0answers
22 views

Numbers never responds

When I try to run Numbers, it bounces for a while, and then just stops. No windows, no menu bar, nothing. When I Ctrl-click the icon, it says not responding, so I force-quit. I have never actually ...
0
votes
0answers
25 views

Does numbers have a way to auto-fill an entire column?

Excel has a feature where when you are trying to auto-fill equations (i.e. you can drag an equation down and it makes an appropriate equation for the next row), you can double-click the drag-handle ...
0
votes
1answer
46 views

Change date format in Numbers 3.2

I recently updated Numbers to 3.2. I want to be able to put a date in a cell numerically (8-22-14) and then have it show up with the month name, day, and year (August 22, 2014) without having to do a ...
2
votes
1answer
27 views

Delete table name

That must be probably obvious, but I can't seem to figure out how to delete the table name. Only the hide option is available. create table default name "Table 1" appears don't want it - and don't ...
1
vote
1answer
30 views

Numbers app lists all file names

When we go to a program we go there to create a new file or resume work in one. When one clicks the Numbers Application icon Why does Numbers in Mavericks list files with different extensions and not ...
0
votes
0answers
36 views

Entering only the time in a iOS Numbers form

I use Numbers on my iPhone to keep track of a few things that have well-defined attributes. Each of these documents has a sheet that acts as a simple database, and a form that I use to enter rows into ...