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
2k 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
194 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
1k 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
1k 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
89 views

Numbers has stopped showing up in Launchpad

Numbers has stopped showing up in Launchpad. How can I add it back?
1
vote
0answers
94 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
67 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
0answers
29 views

Concatenate rows of variable length to a single row in Numbers?

I'm currently trying to write a spreadsheet for scoring students on papers while also storing the maximum amount of points achievable. Each week, a new paper is released with a number of exercises ...
0
votes
1answer
20 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
214 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
197 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
0answers
48 views

How to maintain capital letters within a Numbers files exported as a CSV file?

I imported a CSV file into Numbers which contained emails, phone #'s, first and last names. I cleaned up the data in Numbers so that names started with capital letters and phone numbers contained ...
0
votes
2answers
392 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
100 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
1k 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
385 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
32 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
74 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
164 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
199 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
260 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
56 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
942 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
393 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
152 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
1k 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
112 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
149 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
749 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
5k 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
129 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
1k 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
140 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
36 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
2answers
3k 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
3k 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
196 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
81 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
5k 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 ...
4
votes
2answers
2k 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
137 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
78 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
4k 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
858 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
60 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
2k 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
512 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
2k 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 ...
4
votes
1answer
101 views

How to convert and adapt from a “Save As” person to a “Version” person?

I am so used to "Save As" on the PC, so that for example, if I remember I removed a line two months ago on my resume (also called CV) and now is April 2012, I can go back to Resume 2012-01-23 ...
0
votes
1answer
190 views

Style text in Numbers formula

I have a numbers formula used in invoice generation: ="Invoice terms: "&CONCATENATE(Terms)&", please pay by ..." Which returns: Invoice terms: 14 days, please pay by ... Is there a ...