Questions tagged [numbers]

A spreadsheet application developed by Apple as part of its iWork suite availble for iOS, macOS and cross-platform via iCloud. It is the Apple alternative to Microsoft Office Excel.

Filter by
Sorted by
Tagged with
5
votes
4answers
22k 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.
3
votes
2answers
22k views

Separate multiple comma separated values in Numbers

One of the CSV files I'm using has lumped the address into one single cell, separated by commas. For example: 12 Fairy Tale Lane, Wonderland, Oz, Neverland I need to separate these into Address 1, ...
1
vote
1answer
976 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
vote
1answer
206 views

How do I turn hyperlinks on or off in Numbers?

How do I turn hyperlinks on or off in Numbers5.2? Sometimes when I paste email or links into numbers they appear as hyperlinks other times not. I cannot seem to find any way of changing these (...
2
votes
1answer
959 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 ...
6
votes
1answer
580 views

is there a way to disable update notifications in iWork apps (Pages, Keynote, Numbers)?

Even with App Store Automatic Updates set to OFF, all of the iWork apps pop up a modal dialog box on startup to inform you there is an update. Is there a way to disable this behavior (in El Capitan)?
1
vote
1answer
625 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 really ...
1
vote
1answer
146 views

How to paste information from JSON Helper

I'm able to fetch JSON data using JSON Helper and see the results in Script Editor, under Results. I'm not sure what I would use next in AppleScript to copy those results so I can paste it into a ...
1
vote
1answer
23 views

Disable suggestions as you type on Numbers

It seems that Numbers give a suggestion based on what is already in the sheet. Like in the image. How to disable this?
0
votes
1answer
896 views

Getting the First Cell NOT Containing Certain Text in Numbers

I have a table in Numbers, and I'm trying to get the value of the first cell that contains the character …. In order to do so, I wanted to use MATCH(), but had no luck after I realized it could only ...
21
votes
2answers
6k 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. ...
1
vote
3answers
2k views

Is there an iOS spreadsheet app that can do data filters?

Google Sheets only does data filters in the browser, their mobile app does not support that feature. Is there another iOS spreadsheet app that does support such a feature? Basically, I want to be able ...
3
votes
2answers
1k views

Can numbers copy spreadsheet including formula and paste without the figures?

I use the Mac Numbers app (version 5.1) on a retina MacBook Pro, Safari 11.1.2 I need to copy & paste a spreadsheet to include the formulae, but not the figures? Spefically, my accounts for July,...
0
votes
2answers
944 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 ...
3
votes
4answers
98 views

Find Font used in Numbers

Is there a way to find Font used in Numbers? Opening the spreadsheet on my Mac is fine, but I get this error message when opening the same document on iPad (iOS) The font TIMES-Roman is missing. I ...
0
votes
1answer
61 views

Numbers Sum of all values in a column where another cell within the row matches text

I'm sorry if the title is confusing. I'm struggle bussing hard on figuring out how to write some formula in Numbers. It really doesn't help that the name of the program and functions I'm trying to ...
2
votes
1answer
121 views

Directly input “duration” data type into Numbers formula

I am trying to create a formula in Numbers which takes a duration and calculates what percentage this is of another duration. For example, I have a duration of 1h 30m in cell A1. I want to calculate ...
2
votes
1answer
511 views

Do Pages, Numbers and Keynote for Mac/iOS offer real-time collaboration on shared documents like Pages, Numbers and Keynote for iCloud do?

In Pages and Numbers (I guess Keynote too) for iCloud if you share a document and then send the link to other people you get real-time collaboration between the contributors as they edit the document ...
0
votes
1answer
32 views

Error message “The location of the document “Social Stats record Spreadsheet.numbers” cannot be determined”?

I am trying to save my Numbers spreadsheet and this message (as stated in the question) is showing. I am also trying to export the file as a PDF and this message pops up - The document “Social Stats ...
0
votes
1answer
32 views

Can't swap two columns in a Numbers table by clicking and dragging

I'm trying to swap two rows in a Numbers table, but clicking and dragging on the rows I'm trying to swap is not working at all, like it normally should. What is the problem here?
0
votes
1answer
1k views

How do you remove a hyperlink from a cell in Numbers '08 version 1.0.3?

I have an address in a cell which is hyperlinked. I've also searched other posts on the topic and the selecting text and "right-clicking" does not bring up a menu with how to remove the link. I'd ...
4
votes
3answers
9k views

How to install old iWork on a MacBook with MacOS High Sierra?

I have a new MacBook Pro running High Sierra (10.13.2) and installed current versions of Pages and Numbers. But I need also the old versions (from iWork 9 I think) with mail merge support. I had those ...
2
votes
1answer
7k views

Numbers: divide in a column

I have a price list: 12,560 14,340 11,890 ... Is there a simple way to divide these cells by a number at once?
1
vote
1answer
2k views

Numbers: is it possible to add multiple select elements?

I'm working on template in Numbers. Some cell in template can have only specific values from code lists, so I decided to add pop-up format for them. But some cell can have multiple values from code ...
0
votes
1answer
29 views

How can I describe three different situations on a cell in Numbers

We have business rules as follows: If it is bigger than £35 we charge 75% of it If it is smaller than £20 we charge 70% of it If is is between 20 to 35 we charge 72% of it I don’t know how to ...
1
vote
1answer
89 views

How do I show the sum of multiple ranges in one cell?

How do I show the sum of multiple ranges in one cell? I want to add the sum of C5:C25 to the sum of G5:G25 and divide the answer by 14.
2
votes
1answer
2k views

Apple Numbers IF rules with checkboxes

I have a column A with checkboxes and a column G with Currency can I do a formula to get the total of G only when the checkbox is not tick? in the same idea, I have some dates in column B, and I ...
2
votes
1answer
60 views

How do you wrap the title text of a sheet in Numbers?

Wrapping the text of a cell can be done by control clicking and selecting the Wrap Text menu item so that it is checked (or by using the formatting side-bar. However, there is no obviousuly intuitive ...
1
vote
0answers
36 views

Numbers key combination for “fill down” and “fill right” [duplicate]

I want to be able to fill down certain formulas in a spreadsheet. I DO NOT want to use the mouse or trackpad. I only want to know if there is a key combination like Excel's command+D or command+R I ...
0
votes
1answer
2k views

Applescript read specific data out of iWork Numbers

I am trying to get data out of a table in Numbers. I have an index number, I need to get the name associated with it in applescript. (Eventually I need to set names of files with one of columns of ...
6
votes
1answer
109 views

Does Apple's Numbers support 3rd party plugins / data providers / formulas / functions?

Numbers has the ability to pull in prices for various stocks and currencies. However, I am after the ability for it to pull in prices for various cryptocurrencies, not just BTC, such as Cryptofinance ...
4
votes
1answer
332 views

Counting the number of cells which contain a specific character

I want to count the number of cells which contain the character “1” in an Apple Numbers table row. When the row of cells include (using a space delimiter between cells), 1234 5671 1 8765 6113 2468 ...
4
votes
1answer
5k views

Numbers: Creating a Summary table based on values from different table

I have a table that looks much like this: That Category column is entered manually and will have several duplicated values. I’d LOVE to be able to create a “Summary” table that manages to copy and ...
3
votes
3answers
1k views

Numbers - date cell set to last day of the month

I have a Numbers sheet that I use to forecast the monthly interest payments on my mortgage and it's working well. The only issue is that the date cells auto-sets to the first day of the month. Is ...
2
votes
1answer
160 views

Swap two columns/rows in Numbers

I would like to move column 3 in numbers in between columns 1 and 2. In other words, I would like to swap columns 2 and 3. This is possible in Microsoft Excel. I realize this is possible in Numbers ...
3
votes
2answers
257 views

Numbers: How to escape the “+” character for a phone number

I am working on a document in Numbers where I have to write a phone number starting with a plus character +, like +33553379412, but as soon as I press enter, the plus is going away. Is there any way ...
2
votes
1answer
223 views

How to print one Numbers row per page, formatted nicely

I have a Numbers spreadsheet consisting of data that I would like to print. However, I would like to have each row of the table printed out on its own separate page. Moreover, each row contains a lot ...
3
votes
1answer
2k views

Setting the value of a Numbers cell using AppleScript

I'm trying to write a numbers script (to do this, as it happens), in which I need to change the value of a cell. However, if I do something like tell application "Numbers" activate tell ...
1
vote
1answer
3k 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 ...
4
votes
1answer
576 views

AppleScript and Numbers: How do I add a row?

This has to be simple: I want to use AppleScript to add a new row at the top of a Numbers sheet called WorkoutSheet in a table called WorkoutDB in a Numbers document call Workout.numbers. (Using ...
3
votes
3answers
15k 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.
1
vote
2answers
931 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.
0
votes
0answers
185 views

Numbers 3 or 4: how to copy a chart completely?

I have Numbers 4.3, 3.6 and 2.3 installed on different computers. I want to copy charts from Numbers to Keynote but when I do that in 4.3 or 3.6 the title, legend etc are omitted (and yes, I have ...
3
votes
0answers
107 views

How to find polynomial trendline x value when using a date?

So I have a chart that I have created in Numbers, with a trendline using a polynomial function, and I've got it to display the formula, but I cannot for the life of me, figure out what x value I'm ...
4
votes
1answer
968 views

Numbers 3 - How to apply custom chart style

Using Numbers 3.0 with Mavericks. I am creating a bunch of scatter plots in numbers. I want to remove the big bubbly data point symbols and simply display the data as connected points. Setting this ...
1
vote
2answers
5k views

Using formulas in conditional formatting in Apple Numbers

I'm using Apple Numbers in macOS, and utilizing its conditional formatting feature to compare some numbers, however I want to compare the numbers' absolute value. The numbers I work on are ...
3
votes
1answer
1k views

How do I create a secondary X axis in numbers?

So I have a set of data such that: "Months A/B/C" represent X values, and Cost represents the associated Y value. Combined, there is the data there to plot three different data series on this one ...
2
votes
1answer
8k views

Numbers for OS X Yosemite 10.10.5

I need Numbers for OS X Yosemite. When I try to install from the Apple store, it only gives the option for 4.1. I think I need 3.2.2 or around there. When I try to install 4.1 it complains: I cannot ...
2
votes
4answers
13k views

Batch convert Apple Pages files to Microsoft Word doc files

How can I convert a large number of Pages and Numbers files into corresponding MS Office format in a quick manner.
8
votes
4answers
27k 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 2 3
4
5
11