Questions tagged [numbers]
Apple Numbers is an application for creating spreadsheets and graphs. Use this tag for all versions of this app, web based, iPad and iPhone as well as macOS
720 questions
1 vote
1 answer
56 views
Does specifying the column (i.e. R) as a range specify all of the cells in that column not in the header or footer?
I am using RANK whose 2nd parameter is a "value-set". In my case, I want this to be all of the cells in column 'R' that are in the body of the spreadsheet -- i.e. all the cells in the ...
- 505
2 votes
1 answer
115 views
How to customize iWork Numbers to use a four-digit grouping separator?
I’d like to know how to set a custom number format in macOS Numbers so that digits are grouped every four digits, like this: #,####,####.##. In my language, numbers are grouped by four digits rather ...
- 49
0 votes
1 answer
18 views
A specific colour isn't working with a specific chart series in Numbers
I have a Numbers document with a table and a chart (2D line). I can colour text on the table without a problem; all colours work properly with text. However, one specific colour doesn't work properly ...
- 523
1 vote
1 answer
141 views
Numbers COUNTIF and INDIRECT across multiple sheets
I'm running into an issue with a document I need to maintain that I inherited. There is a table on the main page, in the A column there are date's listed as Dec-10, Dec-11, etc., etc. Each one of ...
- 13
0 votes
0 answers
52 views
Disable STOCK() price update in Numbers before opening file
I'd like to open an old Numbers file that contains calls to the current stock price function and see all the values that it held as of the date it was saved. Can I disable the function somehow before ...
0 votes
0 answers
67 views
How to COUNTIF a Date/Time in Apple Numbers
I have a following set of data [time] [value] ...97 lines... In another table I set intervals like [from] and [to] like 9:00 to 9:09 I'm trying to count occurrences of data in each interval by =...
- 41
1 vote
1 answer
64 views
Sum based on related values in separate tables
I have two tables (sheets) in a single workbook: Table 1: Name, Amount Table 2: Name, Yes-No I want to (sum all of the Amounts) in Table 1 where (Table 1 and Table 2's name are the same) and (Table ...
- 133
0 votes
1 answer
59 views
Space width in thousands separator
I noticed some time ago, that a thousands separator space became smaller in width. No matter if I change locale in system settings, the size of a space stays the same. Can't find any setting to change ...
- 41
0 votes
0 answers
49 views
What’s the syntax for booleans in Numbers FILTER?
I have FILTER(Payment Month, Spending Template::Frequency = "Annual" ) But would like to narrow the Boolean expression something like this: FILTER(Payment Month, AND( Spending ...
- 461
0 votes
0 answers
40 views
Why does collaboration on an iCloud-stored document through Messages and Mail fail with a misleading error message?
I'm trying to collaborate on a Numbers spreadsheet via iCloud. After creating and saving the document, I tapped on the sharing button (iPad Air 2020, iPadOS 18.3), made sure the dropdown menu was set ...
- 1,812
0 votes
1 answer
123 views
Time, duration, midnight - iWork Numbers
I have this table in Numbers: In the first column I want to calculate the differences between the timestamps in the third column. The first four entries in the first column are fine. I just subtract ...
- 3,494
0 votes
0 answers
29 views
Is there some way to toggle visibility of lines in a line graph in Apple Numbers?
In Apple Numbers, is it possible to temporarily hide a line in a line graph? What doesn't work as intended: Hiding the row or column in the corresponding data table changes the line colors and styles ...
user614688
2 votes
1 answer
123 views
Is it possible to format numbers in scientific notation without the horrible E notation in Numbers?
I dislike the way Numbers displays numbers in scientific notation (e.g. 4,000 would be 4E+3 or 4E+3). I'd like it to display them in proper scientific notation as used by scientists (e.g. 4,000 would ...
- 523
1 vote
0 answers
30 views
How do I assign a keyboard shortcut to an application-specific script?
I've created a Javascript filed as Submit form JXA in ~/Library/Scripts/Applications/Numbers. Submit form JXA appears as a menu item in the Scripts menu when Numbers is front window. Clicking this ...
- 461
0 votes
1 answer
142 views
MacOS: Numbers export CSV line endings
Using Numbers 13.0 on MacOS. When I export my table to CSV format, the generated file has strangly CRLF line endings. How can I teach Numbers to use normal LF line endings instead? It is cumbersome ...
- 1,480