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
18 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
12 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
10 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
21 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
18 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
17 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
9 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
10 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 ...
59
votes
3answers
23k 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
24 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
16 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
13 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
18 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
46 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
52 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
12 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
29 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
23 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
11 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
92 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
35 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
40 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
42 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
37 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 ...
1
vote
0answers
387 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 ...
1
vote
1answer
220 views

How do you rotate a cell in Numbers (3.2)?

I want to rotate the header row by 45 degrees to look like this (from Excel). How do you do this in Numbers?
1
vote
1answer
32 views

How do I change the sheet color in Numbers 3.x?

Right now the sheet color is white. But it is hard on my eyes. How do I change the sheet color to black? I'm using a Numbers 3.x in OSx 10.9.3
-1
votes
3answers
94 views

Equivalent of cmd+down in Numbers

This is the key combination I would use in MS Excel to jump to the last contiguous cell in the current column. Similarly, cmd+shift+down would perform the same jump while selecting all the cells along ...
2
votes
1answer
23 views

Change Default Table Style when opening a CSV file

Background I often open a CSV file on Numbers, and then I see the table of which style is 'Basic'. I want to use another style (e.g. 'Gray'), but it's annoying to change the style every time I open ...
2
votes
1answer
18 views

Sequential numbering for pseudo-“Rows”

tl;dr: Formula to number rows that doesn't break when some "rows" are made of multiple, merged spreadsheet rows. Scenario: I am making a check-list (of things to look at when apartment-hunting) in ...
1
vote
0answers
34 views

How to write a function in Numbers to get the DATES for different tasks

I am trying to figure out how to write a function to get Dates going on and back from a different moments in my to-do spreadsheet. I know that i can use function DATEVALUE() to count from one specific ...
1
vote
1answer
28 views

One Odd-Sized page in Pages Document for PDF

Need to embed a Numbers spreadsheet in a Pages doc that will “live” as a PDF. Generating a scaled image that I then embed results in mediocre resolution.
1
vote
0answers
26 views

Numbers '08: How to create a histogram?

I have data (ranging from 0 to 1, e.g. 0.61 0.23 0.99 1.0 0.89 0.0 0.42 0.42 0.86 and I would like to create a histogram with bins 0 0.2 0.2 0.4 0.4 0.6 0.6 0.8 0.8 1.0 with the upper ...
1
vote
1answer
132 views

Comma separated list to Columns / Mac Numbers

I have a very huge list of Data (.txt file) .e.g. 945874,stu2,3826,120558,74,15 1836682,CHAOSTAURUS,90,978,3853,0 1411981,KasiaLover,101,28285,684,5 8270041,Daniel33de,3883,2389,2397,1 ..... etc ...
2
votes
2answers
77 views

Directory contents into a spreadsheet entry

I would like to turn the contents of a folder into entries for Numbers (or Excel) - is there a way to automate doing this?
0
votes
0answers
35 views

How to calculate total rental income of a property in Numbers?

I'm trying to calculate the total rental income of a property which increases in value over time. If I assume that the rent will always be 5% of the property value, and that the property is initially ...
1
vote
2answers
38 views

Keyboard shortcut for prev/next sheet in Numbers 3

is there a keyboard shortcut for moving to the next or previous sheet in Numbers 3? I have a dream I found those shortcuts, but can't seem to figure out what they were...
0
votes
0answers
35 views

Numbers 3.1: Maintain Link to CSV

Is there a mechanism to maintain a link between a CSV that may change and a Numbers file? I would like to maintain a Numbers file that uses table data from a CSV whose contents will be updated every ...
0
votes
0answers
27 views

Map date and time entries to single day in Numbers

I am keeping track of a certain value that varies during the day, and from day to day. I make entries in my Numbers table as I get the values during the day. Column A is the time entry: month day year ...
2
votes
2answers
73 views

Numbers: Countif with condition the content of a cell

I am struggling to come with a solution on this problem, making me wonder if the Countif function is designed to work this way, or what is wrong with my syntax at the end. I have my first table with ...
1
vote
1answer
27 views

Tracing the forward use of values in formulas in Numbers

I use Numbers version 3.1 on Mavericks. One can easily look at a formula in a given cell and immediately see the other cell references it uses. I think of this as a backwards look. Does any means ...
2
votes
0answers
27 views

Numbers 2: Create a new header cell, listing once the contents of a column

Not sure how to search for this question, and moreover I rather think that what I want might not be possible, but just in case I am asking it here. I am looking for a way to create a new table where ...
3
votes
1answer
256 views

Numbers v3.1: Automatically link URLs in spreadsheet?

I've inherited a spreadsheet that has a loooong column (thousands) of URLs, all unclickable. I'd like to make them clickable. I have tried the following: Highlighting the column. Select column, ...
2
votes
0answers
66 views

How do I sort a Numbers' table using data from another table?

So, I've got this data set coming from questionnaires. I created one table per question, questionnaires in rows, answers in columns, and everything is fine and dandy, but now I have this situation ...
1
vote
2answers
685 views

How to display zero value as blank cell in mac numbers 3.1

How do I display zero value as blank cell in mac numbers 3.1 yet maintain a formula. I want a running balance column that only shows balance to the line of the last entry like a checkbook register. ...
0
votes
0answers
69 views

How do you get different color bars in Numbers 3.1?

In previous versions including 3.0 when you made a 3D Bar chart each data point (ie. months) would be in a different color - now I can't seem to find any way to make them different. Is this a bug in ...
1
vote
0answers
28 views

Latest Numbers changes, how to graph things?

Ok this is insane, I have a table Selecting both columns, and What i get back makes no sense. Plotting columns as series i get Plotting rows as series i get Things worked perfectly fine ...
1
vote
1answer
72 views

Insert MathType Equation is disabled in Numbers

I am running Numbers 3.1. When I try to select the Insert > MathType Equation... option, it is disabled. There doesn't seem to be anything in the help related to this feature. How can I use this ...
2
votes
0answers
36 views

How to calculate max with condition in Numbers?

How can I calculate max with condition in Numbers? In other words, I want something like maxifs, which operates max operation instead of sum operation for sumifs.
1
vote
1answer
105 views

Updating a chart dynamically in Numbers

Background: I've been having some sleep issues so I have started tracking my sleep habits along with some other data but so far, they are just entries in Evernote and as such it is not possible to see ...