A spreadsheet application developed by Apple as part of its iWork suite. The iWork equivalent of Microsoft Office Excel.
8
votes
4answers
420 views
How to Change File Type Associations?
How do I stop Numbers from being the default program when a financial file is downloaded or imported?
5
votes
3answers
3k views
How to convert .number file to any of the readble format including excel and pdf without having mac
I have an important .number iworks file. My Mac is now no more... How do I convert .number file to any of the readble format including excel and pdf without having mac.
5
votes
2answers
1k views
How do I keep Numbers from mangling numbers when importing a CSV?
When I open a CSV file in Numbers, it "helpfully" converts fields it recognizes as numeric by stripping leading zeros, converting things it recognizes as dates, etc.
Take for example, you type a UPC ...
5
votes
1answer
335 views
Keyboard Shortcut to Fill Right in Numbers?
In Numbers, is there an equivalent keyboard shortcut to Excel's "Fill Right" Ctrl + R and "Fill Down" Ctrl + D?
4
votes
2answers
778 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
88 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 ...
3
votes
2answers
302 views
Is there a keyboard short cut to edit a cell in Numbers?
Back when I used Excel you could easily do all the navigation and editing on a spreadsheet with the keyboard. I could navigate around with the arrow keys and hit F2 to edit a cell and start typing.
...
3
votes
2answers
395 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
3
votes
1answer
1k views
How do I open XLS files in Numbers?
I've just bought Numbers and I'm trying to open some XLS files. They're in Excel '97 format, not encrypted, and with no password set. However, when I try to open them, I get this error message:
...
3
votes
2answers
6k views
Swap X and Y axes in Numbers?
I'm taking an economics course, and for whatever reason economists create graphs with the independent variable (price) on the Y axis and not the X axis. If I only have 1 dependent variable to graph, ...
3
votes
2answers
2k views
Why can't I see my Numbers spreadsheets on my new iPhone?
I had been using Numbers on my iPad and on my iPhone 4. The spreadsheets were synced perfectly over 3G and wifi. However, I just bought an iPhone 4S. The spreadsheets are missing when I open ...
3
votes
2answers
1k 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
2answers
236 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 ...
2
votes
2answers
2k views
iWork '09 Keeps asking to be Registered
I'm a teacher in a classroom with 8, 9 10 and 11 year olds who each have a macbook or a macbook pro. Fun job. We have a standard 10.6.6 image with iWork '09 (4.03).
In previous images, iWork would ...
2
votes
1answer
2k 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 ...
2
votes
2answers
7k views
Can Numbers ’09 import an Excel XML file?
Can Numbers ’09 (part of the iWork suite) import XML files? Specifically, the format created by Excel when exporting as "XML Spreadsheet 2003."
I can't just use Excel's native format because the ...
2
votes
1answer
56 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 ...
2
votes
1answer
268 views
How to setup Indian rupee format in Numbers?
Indian rupee number format is different from US number format.
e.g. 1,00,00,00,000
http://en.wikipedia.org/wiki/Indian_rupee
How do I setup a custom number format in Numbers?
2
votes
1answer
645 views
How do I insert radio buttons in Numbers for iPad?
I need to insert radio buttons on a Numbers spreadsheet. I tried importing an Excel document with form radio buttons, but it did not pull through. Advice would be appreciated.
2
votes
1answer
222 views
Is there an equation in Numbers that will give me the sum of numbers based on a separate column?
I'm trying to find out if there is a way to create an equation that looks at one column, if it is equal to a certain value, then add the value in the other column?
Example:
#Table of running values:
...
2
votes
1answer
690 views
2
votes
2answers
44 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 ...
2
votes
1answer
215 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
1answer
73 views
How do I insert a function along with a word in numbers
I am using numbers and I have a column function at the footer row. I'd like it to produce a Countif() along with a word.
I tried: =Countif(Checkboxes,True) "Checkboxes"
so that it would express for ...
2
votes
0answers
65 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 ...
2
votes
0answers
822 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 ...
2
votes
1answer
2k views
iWork '09 Numbers: How to set the default language of the document
I would like to set the default language of a Numbers document. I figured out how to do it for a Pages document:
How Do I Set the Default Language in Pages?
but I cannot find the corresponding ...
2
votes
1answer
132 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?
1
vote
1answer
299 views
Transfer values between tabs in Numbers for iPad
I have two tabs in one spreadsheet in my Numbers for iPad. Is there a way I can transfer a value between those tabs?
1
vote
2answers
8k views
How to import a spreadsheet into Numbers from an email attachment?
I want to know how to open a spreadheet email attachement in the Numbers app on the iPad.
Here are the steps I have taken with no luck:
On the iPad I open my email.
I see a spreadsheet attachment.
...
1
vote
1answer
89 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 ...
1
vote
1answer
78 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
1k 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
2answers
252 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 ...
1
vote
1answer
444 views
Floating row in Numbers for iPad
Is there a way I can make a row float on top of everything else. So, no matter how many rows you add, the row will always be visible?
1
vote
1answer
23 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
67 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 ...
1
vote
1answer
101 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
35 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
1
vote
1answer
70 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 ...
1
vote
1answer
144 views
In Numbers, how can I determine the default formatting of cells in rows that have just been added to a sheet?
When using Numbers, I have noticed that whenever I add a new row above existing rows, all of the formatting for the new row is exactly like the rows below it. However, if I add a new row below ...
1
vote
1answer
132 views
Can tables from Pages be reused in Numbers to create graphs?
I created a table in Pages '09 and pasted it into Numbers '09 to see if it worked, then I created a graph for it, still in Numbers, but the graph displayed no data as you can see from the screenshot.
...
1
vote
1answer
26 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 ...
1
vote
1answer
328 views
Cannot create new documents or open any existing ones in iWork(Pages, Keynote, Numbers)
For some reason I can't seem to create new documents in any of the iWork apps. Whenever I press the File->New button nothing happens. I've tried turning on and off iCloud synchronization but it didn't ...
1
vote
1answer
73 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
0answers
49 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 ...
1
vote
1answer
140 views
Numbers: How can I display negative values in a column chart?
I am using Numbers '09 v2.1 (436) and I have a table having positive and some negative values. When in my project I add a column chart mapping properly data from that table it displays a chart without ...
1
vote
1answer
521 views
hyperlink to another worksheet in Numbers 09
Is it possible to hyperlink to another sheet in the same workbook in Numbers '09? I want to have a link so I can jump back and fourth between sheets. Excel has this feature but I can't find anything ...
1
vote
2answers
300 views
What causes all iWork apps to have blank, unusable documents after a reinstall?
After deleting and re-installing the apps, I can't use iWork. Specifically, the document area is always empty, no matter if I create a new document or open an existing one. This applies to Pages, ...
0
votes
3answers
316 views
Can Numbers save a file as CSV?
I'm trying to switch over from Excel to Numbers. Is it possible to save a file as a CSV in Numbers?
The whole idea behind this is I prefer to have my documents on the cloud as well as on Numbers for ...
