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
1answer
19 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
9 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
12 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 ...
3
votes
0answers
54 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
15 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
34 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
10 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
10 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
27 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
13 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.
1
vote
0answers
13 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
38 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 ...
0
votes
1answer
39 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
143 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
23 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
18 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, ...
0
votes
1answer
30 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
22 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
27 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
42 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
30 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 ...
0
votes
0answers
18 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
80 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
0answers
70 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
23 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
20 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
21 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
27 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 ...
0
votes
0answers
25 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 ...
1
vote
1answer
25 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
17 views

Numbers 'Not Responding'

I have a problem opening one particular Numbers spreadsheet on some of our computers but not others. All are running 10.8.3 any clues? I have tried changing the file name, holding down the shift key ...
0
votes
0answers
18 views

Loading xlsx file in Numbers, Filter Table is disabled on columns

I loaded an Excel file (XLSX format) with a table in Numbers, where I had filtered out some data based on a column (using Excel's column-based filtering options). In Numbers, I only see the filtered ...
62
votes
3answers
24k views

Why does Numbers hide a huge PNG file in exported Excel sheets?

OK, this is a weird one. I take my blank Numbers sheet: ...and export it to Excel: Whoah, that seems a little large. Let's rename the Excel doc to .zip and have a look inside: Digging a ...
0
votes
2answers
30 views

Two numbers on one phone

I recently moved to USA for 10 months so I had to get an American number. Can I keep my old foreign number? If so how do I do that?
0
votes
1answer
25 views

Can't find SUMIF in my Numbers functions. Could someone tell me where to find it?

For the first time I am working with Numbers rather than Mac Exel, which I was running on my old G4. I now have a 2012 MacBook Pro with Mavericks, and the one function I use more than any other is ...
1
vote
0answers
39 views

How can I restore an older version of a Numbers document (before the sync)

I'm using Numbers on my iPad and my Macbook. Yesterday I opened my Macbook and for some reason it opened the Numbers app but didn't sync. I didn't really need to work on the file so I just left it ...
0
votes
0answers
25 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
0answers
63 views

Can't use any of the iWork apps

I'm unable to use any of the apps included in the iWork package. If I try to open any one of them, the app opens but I can't perform any action. I click on the bar menu items to see that even 'About ...
1
vote
2answers
122 views

Convert Numbers.app spreadsheet to JSON document?

Is there a way to export a Numbers.app spreadsheet as a JSON formatted file? I know I can do it manually but this will be used as data input to an iOS app and I'd like to have an automated way to do ...
2
votes
1answer
13 views

Can I have multiple graphs in the same place in Numbers?

I have a spreadsheet with a bunch of graphs based on a table. Instead of having a long list of graphs, is there a way to display these graphs all in the same space, but change between them? And to ...
1
vote
0answers
30 views

Sum of Formula results?

Is there any way in Apple Numbers to apply a formula to a selected set of rows, and sum up the results? This is how i'd like to have/use the formula SUM(TableA::$A$1:$A$20;"=$1*"&TableB::A1) ...
0
votes
0answers
51 views

Removing random gridlines in Numbers

How can I remove gridlines in Numbers? I have cleared all the gridlines and still can't remove from two rows. Is there a way to remove them?
0
votes
0answers
14 views

Maverick update to network and now Numbers documents on server locked

We updated Macs on network that are new enough to Mavericks. This included the server. Now all the Maverick computers are locked out of Numbers documents on server. The non Maverick computers can ...
2
votes
1answer
214 views

OSX Numbers 3.2 inserting date / time

I want a cell to take on the date and time of "this moment", and then leave it. Contrary to some experiences I've read about, the Insert menu does have Date & Time, but it doesn't seem to respect ...
2
votes
1answer
59 views

How to handle Numbers' automatic Data Formatting?

I'm trying to put together a sheet that calculates hours I work. One thing I want to do is calculate hours that are billable. So I have something like this: Things that aren't billable or are ...
0
votes
0answers
75 views

Copy Paste formula in Number 3.2

I have20 three-member groups with different individual measures. So, I have a sheet in which I have 60 (20*3) rows and number of columns )+ heading row). I also have another sheet in the same file ...
0
votes
1answer
88 views

Why does the message icon show only for one number

In one of my contacts I have added two phone numbers. I want to know why the message icon that let's me text to this number show up only for one of the two numbers as well as how can I fix this.
0
votes
0answers
46 views

How to display labels on bubble chart, Numbers (v3.2)

I want to display the label of each bubble on a bubble chart in numbers. How do you do this? I want either a truncated "description" or the 3-digit NAICS to be the label of the bubble. Here's an ...
3
votes
0answers
996 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 ...