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
1
vote
0answers
9 views

Formatting of negative currency values in Numbers

For some reason Numbers insists on formatting a negative value in a "currency cell" as € 10.99- instead of for example € -10.99. I have tried messing around with the settings in the Language and ...
1
vote
1answer
58 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
908 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
2answers
2k views

Apple Numbers program, weird thing with unix time code formula

Hi I have applied the unix time code formula =(((A1/60)/60)/24)+DATE(1970,1,1)+(-5/24) And it works! But the result I get on my column only shows the date and not the time. Does anyone know how to ...
6
votes
1answer
483 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
618 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
128 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
18 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
821 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
416 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,...
1
vote
0answers
49 views

Keynote: How to reference a page relative to the current one?

I want to embed tables (from number) in a keynote document. In such a table, I want to reference cells of different tables from different slides. I know that I can address such a table by an absolute ...
0
votes
2answers
835 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
8answers
12k views

Remove hyperlink formatting from address

I have created a Numbers spreadsheet containing a set of data including email addresses. Some of these addresses appear as hyperlinks, and I can't seem to edit or change them. Every time I try to ...
3
votes
4answers
69 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
27 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
51 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
506 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
26 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
22 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
964 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
3k 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
1k 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
27 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
72 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
944 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
46 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
28 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
79 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
146 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 ...
3
votes
1answer
4k 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 ...
1
vote
1answer
71 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
211 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
103 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
410 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
728 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.
2
votes
1answer
871 views

(Numbers) COUNTIF values from one column match another column?

I have a Numbers file containing some rows with machine learning predictions and also what the actual values were. The first column contains an unique ID, the second column contains the actual values, ...
0
votes
0answers
140 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
86 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
956 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
3k 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
695 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
7k 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 ...