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

Where has Numbers gone?

I created several spreadsheets in Numbers. Lately I have been using Excel, which won't open them. I can't find Numbers in my application folder--is it hiding somewhere??
0
votes
1answer
1k views

Mac Numbers date functions

Can I colour a cell red if todays date is on or after the date I have entered in the cell? I have tried the IF function and conditional formatting but cannot make it work...
0
votes
2answers
63 views

Numbers.app - How do I add a series of columns

I have a spreadsheet with about 600 rows and 20 columns. I want to add a unique identifier to each cell so that I can use the exported CSV output in another app. So I thought that I could add a ...
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.
2
votes
1answer
3k views

Numbers Won't Open On My MacBook Pro with OS X 10.8.5

I'm not a tech or computer expert - I understand clear directions, but not tech-speak, so I'm going to put this as plainly as I can… I've updated to the most recent system, OS X 10.8.5, on my MacBook ...
0
votes
1answer
265 views

Any suggestions for an ultra-lightweight spreadsheet-like application?

Does anyone have a suggestion for an ultra-light spreadsheet application which is very fast and snappy? I do most of my deep analysis using advanced statistical programs and I manipulate ...
1
vote
1answer
2k views

New Numbers has no Auto-Complete?

It would appear that my documents in Numbers (since upgrading to 3.0 with Mavericks) no longer auto-complete cells. I've Googled for "turn on auto-complete in Numbers" and found plenty of questions ...
5
votes
3answers
2k views

How to store new iWork (2013) documents in a flat file (for version control)?

With the October 2013 iWork update, the new UI is great but it seems one cannot store documents as 'flat file' any more. This really limits my ability to store the files, essentially ruling ...
0
votes
1answer
100 views

Numbers has stopped showing up in Launchpad

Numbers has stopped showing up in Launchpad. How can I add it back?
1
vote
0answers
114 views

Is there a way to create a polar plot in Numbers?

I am trying to do a polar plot, or radar chart as excel calls them, for a report. I don't have excel, only Numbers, is there a way to do that type of plot with Numbers? I can't seem to find a way. The ...
1
vote
1answer
78 views

Performance of Numbers 3.0 for large calculation sheet

When I used previous versions of Numbers to work with files containing a lot of large formulas, the performance of many actions were slow, including scrolling. Can you comment how about the latest ...
0
votes
1answer
28 views

Numbers floating sheets

In Numbers, how can I get the spreadsheet to remain stationary on the page? I have tried to double tap thinking that would display and anchor the sheet but it doesn't work.
1
vote
1answer
1k views

How do I sum up specific things in Numbers?

I have a spreadsheet in the newest iWork Numbers.app, with something like: CATEGORY | POINTS HW | 100 HW | 100 NW | 12 HW | 50 NW | 23 I want to just sum up all the ...
0
votes
2answers
567 views

Numbers regex for stripping domain from email address

I have a field that contains email addresses, I want to use regex to strip everything before the @ symbol to give me just the domain e.g. john@apple.com => apple.com jill@apple.com => apple.com ...
0
votes
2answers
500 views

Numbers spreadsheet can't be imported

I have a spreadsheet I have been updating in IOS Numbers for several months and I sometimes update it with OSX Numbers However when I did a recent update in OSX I get the error message Spreadsheet ...
1
vote
0answers
137 views

Exporting CSV with Numbers with different languages

I am exporting a file from Numbers to CSV and it contains language other than English, like Japanese or Russian. After I export the CSV, all these funny characters shows up in the CSV. Is there a ...
2
votes
1answer
2k views

How to change cell background color in numbers according to some rules?

Making it simple, using Numbers, how can you set up the following: If number is positive make background cell green, else make it red
1
vote
1answer
567 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 ...
2
votes
1answer
34 views

How to make Numbers accept the “.” instead of the comma “,” when inserting data?

I'm from elgium. In Dutch, as probably in some other languages, you write numbers like this: 3,141592, where in English it'd be 3.141592, but the Numbers app only interprets my input as a number when ...
0
votes
1answer
83 views

How to stop Numbers from beeping at me when I use the arrow keys?

When I edit spreadsheets in Numbers, I often hold down the left or right arrow key to get to the far-left or far-right column of a table. Numbers always beeps at me when I do this. It seems to think ...
1
vote
1answer
207 views

How to disable default alt-left / alt-right keyboard shortcuts for Numbers.app

I'm continually hitting Alt+Left Arrow to move navigate within a cell in Numbers, and inadvertently inserting new rows.. How can I disable all the Alt+Arrow shortcuts? I've tried changing the ...
1
vote
1answer
313 views

Select statements in Apple Numbers '09

I've got a table as follows | Name | Year | Price | |____________|_______|_______| | Foo | 2013 | $10 | | Bar | 2009 | $3 | | Baz | 2010 | $100 | What I'd ...
3
votes
1answer
343 views

What's the Numbers equivalent to Excel's “A1:A10-B1”

I'm switching from Microsoft Excel to Number.app, in Excel you can do =SUMPRODUCT((A1:A5-A1)^2,B1:B5) the a1:a10-b1 bit will return a cell range equivalent to a1:a10 but with all the cells ...
3
votes
2answers
60 views

How to convert a chain into a number

In Apple Numbers I want a cell to have 4x8x7 (or 4*8*7) to show the detail of the volume, and in another cell I want that volume calculated 4*8*7=224 based on the first cell. But it doesn't consider ...
1
vote
1answer
2k views

How to convert a Numbers file to .pdf and still have its formula work

Is there a pdf creator or something that I can convert my Numbers file with all its formula still working. The file is a price calculator with choice of products. I dont want the client to change ...
0
votes
1answer
726 views

Making and applying a custom design to a chart in Numbers

I'm making a column chart about certain dice rolls in the game Descent: Second Edition, and the problem I'm having is that there are multiple dice of the same color in the standard rolls. For example, ...
2
votes
1answer
172 views

numbers: Copy/paste of cells messes up my formular

When I copy a cell (see picture 1) and paste it (see picture 2) the pasted version of the formular is messed up. As you can see there are some parts of the pasted formular which are not colored ...
2
votes
1answer
2k views

Numbers: Can I highlight the row and column of the selected cell?

When reading larger spreadsheets, it would be helpful to highlight the row and column that the currently selected cell is in. I'm not talking about conditional formatting or anything in the ...
1
vote
1answer
130 views

Is it possible to change the font and button size of the format bar in numbers '09

I need to increase the size of buttons and front on the format bar in numbers '9
0
votes
1answer
164 views

iWork Numbers increase column size for sum

If I have columns that sum at the bottom, how can I have the sum function automatically include a newly inserted row. a +---+ 1 | 1 | 2 | 1 | 3 | 1 | 4 | 1 | +---+ |=sum(a1:a4)| Then when ...
1
vote
1answer
1k views

How to set default number formatting in Numbers?

In Numbers, I've seen how to change the default cell colour and font, based on table styles. But how can one change the default number formatting? The default "American" formatting for dates, for ...
1
vote
1answer
6k views

How to install Pages, Numbers and Keynote on Snow Leopard?

I just purchased a used 2006 MacBook Pro with OS X 10.6.8. I went to the Mac App Store and tried to load Pages, Numbers and Keynote, and it said it could not load them unless I had 10.7. When I try ...
1
vote
1answer
158 views

How can I assign custom colors to groups in a dispersion chart in Numbers?

I have a table with measurements of the runtime of different sorting algorithms. This data should be shown in a chart, with the number of items on the X axis and the runtime on the Y axis. To make the ...
1
vote
1answer
3k views

How to plot a histogram to show occurrence of a certain number using Numbers

Sorry for this newbie question: I want to do something like in a column there are numbers 0.2, 0.3, 0.2, 0.4, 0.2 occur 2 times, whereas 0.3 and 0.4 occur once, I want to make make histogram that ...
1
vote
1answer
177 views

Numbers create a chart with transposed data

I'm willing to use numbers to create a chart. Unfortunately it is creating the chart using the rows of my data source and I can find how to tell it to use columns instead. Do you know how I could ...
0
votes
2answers
40 views

How to transfer numbers docs from lion on 2006 iMac to mountain lion on another computer (MBA)

My iMac has OSX lion and cannot be upgraded further. How can I transfer iWork documents to my new MBA using mountain lion?
3
votes
3answers
4k views

Is it possible to do conditional formatting in Numbers for iOS?

Is it possible to do conditional formatting in Numbers for iOS? I'd just like to change the text or background colour depending on the cell's contents.
2
votes
5answers
5k views

Is it possible to remove cell borders from Numbers?

I imported an Excel spreadsheet that contained a few cells with black lines as their border. Is it possible to remove these outlines through Numbers (iOS)? I have tried copying and pasting, the ...
0
votes
1answer
216 views

Do I need to wait for an upload to complete before closing Pages/Numbers?

After updating a Pages/Numbers document in iOS, I can go back to the app's file browser to get the list of all of my docs in iCloud. At that moment, the document that I had just updated displays a ...
1
vote
2answers
101 views

Using the Numbers app, how to make 2 plus +0.25 become 2.25?

When a row in a table from a webpage is copied to the Numbers app, such as 2 3 4 5 and another row is copied, as some "deltas" (minor addition or subtraction): +0.25 0 0 -0.5 ...
5
votes
2answers
6k views

How can I change the data source of a chart in Numbers '09?

I have made a chart in Numbers '09 and now I want to create another very similar chart but with different data, so I have copied and pasted the chart and now I want to make it take its source data ...
5
votes
3answers
5k views

Numbers: Count unique items in a column

I'd like to count the occurrence of unique items found in one column of about 120 items. I can't find a way to do this in Numbers.app
2
votes
0answers
190 views

What is the Numbers keyboard shortcut to get in the formula bar of a cell?

I am looking for a keyboard shortcut in Numbers to edit the current cell via the formula bar (if that is the right word). Screen shot: Please note, I am not looking for this answer. That is how to ...
1
vote
0answers
94 views

Is there a way to have a formula in numbers 09 return an empty value (ie isempty() returns true?)

I've got a list of times and ages, and want to extract ages for a particular range of time values. So I've used an 'if' formula to copy the age for an entry if its time is between two values. The ...
5
votes
1answer
7k views

How do I do a pivot table in Numbers?

I can't find any equivalent of the Excel Pivot Table or Open Office Data Table features. I'd like to sum up my data grouped by values in various columns. For example, if I have A B C red ...
4
votes
2answers
1k views

How can I rename the columns in Numbers?

I'm working with a language file, with columns for different languages. My first row is the language names. Is it possible to have the "A", "B", "C", etc as language names instead. That way, when ...
0
votes
1answer
63 views

Cannot overwrite columns in Numbers for iPad

When i start writing text on my iPad in Numbers, i have to stay in one column and can't overwrite the next column. For example: I write something in Numbers on my Mac, the next column gets filled ...
5
votes
2answers
4k views

Link information between spreadsheets in iPad using Numbers

Could you link to data in one spreadsheet from another using Numbers for iPad?
3
votes
1answer
669 views

Is it possible to change text size & formatting of Numbers' formula input field?

Is it possible to set the text-size and possibly other formatting of the actual values/formula input field in Apple iWork Numbers? Comparing these two screenshots, it seems possible to set the size ...
2
votes
2answers
3k views

How do I move a row between two rows in Numbers?

Simple question. In iWork's Numbers, is there any way to move a row of data between two rows, as opposed to just plopping it on top of existing data? You can easily do this in Excel if you hold down ...