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

Filter by
Sorted by
Tagged with
0
votes
1answer
13 views

In Numbers, how to navigate on text inside a cell after pressing Control+Option+U?

In Numbers we can use the ControlOptionU shortcut to edit text in a cell. Doing so the cursor goes to the end of the cell (the right side) here. What if I want to edit in the middle of the text? One ...
2
votes
1answer
51 views

Almost all Functions in Numbers on MacOS Give Me Syntax Errors

Almost all functions I try to use in Numbers give me a syntax error with no explanation what is wrong (red triangle with exclamation mark, only says "The formula contains a syntax error." ...
1
vote
3answers
27 views

Need Mac Numbers & Pages for Mojave

I have a 2010 MacPro running Mojave. I've been trying to buy, copy, or steal copies of Pages and Numbers for hours just so I can work on a client's Pages file. Why is this so hard?
0
votes
0answers
27 views

I'm trying to split text from numbers and sum up total amount from the last numbers

I build an shortcut that helps me following my medicine consumption and I want to get info once/two a day regarding the total amount I consumes at the same day/In the last week and so on. This is how ...
0
votes
1answer
48 views

How to download and install updates to these Apple apps in this macOS without an Apple ID? Can I download the installer? If so, from where exactly?

I need to update Numbers, Pages and Keynote on macOS 10.15.7 but I do not have an Apple ID. Is it possible to update macOS without Apple ID? has an answer which is insufficient for me and is closed so ...
0
votes
1answer
12 views

Range of values for a cell in Numbers?

Is it possible to have a range of values for a cell in Numbers? E.g. for financial calculations involving income and costs, is it possible to have a "vague" value like $ 1,000 - 3,000, and ...
0
votes
0answers
11 views

Apple - numbers - how do i automatically retrieve cell data from different sheets?

I am creating a performance calendar that includes an overview sheet named "MONTHLY" that has columns named "WK 1", "WK 2" and so on for each week of the year. In each of ...
2
votes
2answers
74 views

How to determine if all items in a list are the same

I'm currently in the works of an AppleScript calculator that extrapolates arithmetic linear sequences (sounds fancy but it really isn't). One of the processes it must go through is finding the common ...
0
votes
1answer
30 views

How can I combine text in multiple rows into one text block in numbers?

I am attempting to automate a set of instructions that have variables. I can combine the text across the rows. But I need to then combine each of the final rows together for one simple text block that ...
0
votes
1answer
18 views

How to add a calendar month to a date?

In Numbers, if I have a column for dates, and I want each cell to be one day later than the cell above, I can enter a date in the first cell and then set the next cell to be "cell above plus one&...
0
votes
1answer
14 views

Numbers MAX Formula unexpected result

Goal: Display MAX (greatest) current result from column which keeps growing Current issue: I can have all current entries regarded, however a newer, higher value gets ignored. Attempts to set up : =(...
0
votes
1answer
37 views

How to import text to columns and import numbers to text in macOS Numbers?

Windows Excel allows me to paste a body of text and in the bottom right corner of the pasted content, a menu prompt will pop up that can initiate the "Text Import Wizard" to import delimited ...
0
votes
1answer
21 views

Numbers : sum if tick-box on next column is true

I have 3 column in a numbers sheet (A) Text | (B) Currency | (C) Tickbox At the end of (B) Currency, I have a very basic formula SUM(B) What I'm trying to do is to have the same SUM(B) at the footer ...
0
votes
0answers
6 views

Is it possible to have a second table of Numbers data sized dynamically based on the first?

I'm making a Numbers inventory sheet of cable and hardware plug tips. The first table is just an unformatted log of devices I'm adding, with the columns: Device Name | Plug Type iPhone | ...
1
vote
1answer
63 views

Unable to collaborate on a Numbers spreadsheet

I have a Numbers spreadsheet that I have previously setup to use Collaboration with my wife. A few weeks ago, as I was editing the spreadsheet on my Mac, Numbers told me that it couldn't connect to ...
0
votes
1answer
16 views

How to configure the category gridlines in Numbers?

Below are two charts with and without gridlines. Obviously the one with gridlines isn't very useful. I would like to just have a gridline every 10 years or something like that. How do I do that?
1
vote
1answer
38 views

Generate TSV/CSV with multi-line cells that open in Numbers

I want to programmatically generate tsv files with multi-line cells that stay preserved when opened in Numbers app. What newline character to use to enable multi-line cells?
0
votes
0answers
16 views

How to join a range in numbers?

I want to join the cell values of a certain range to a list with some separator. Example Given this table | A | 1| 7 | 2| a | 3| 4 | .| . | .| . | .| . | If the delimiter I choose is || the resul ...
1
vote
1answer
33 views

Search Numbers spreadsheet for \n

If I search for "\n" in a Numbers spreadsheet, it only shows me any cells that have line breaks in them, it does not show me cells that have "\n" written in them. Is there any way ...
0
votes
0answers
7 views

Is there a way to get a current (15 minute delayed) stock quote into Numbers?

I know about STOCK and STOCKH but both of those are only good for the close of the previous day. Is there a way to get the current stock price, which would probably imply a 15 minute delayed price, in ...
0
votes
1answer
14 views

Cell formula based on finding an index on another sheet

I have a numbers file with a first sheet like this: Then a second sheet that looks like this: For each row in sheet 1 I need to find if there is a matching SKU on sheet 2 (sheet 1, col N with sheet ...
0
votes
1answer
18 views

Import text from webpage directly into Numbers cells

In a numbers file I am using, whenever I open it I need to manually import a specific value from a webpage. Specifically, from this webpage I want to import the USD to EUR ratio. Any other similar ...
0
votes
0answers
8 views

Apply conditional highlighting to a cell range based on a single cell in Numbers

In Google Sheets, I was able to conditional highlight a cell range based on a single cell. The rows in this image are colored based only on the value of cells in Column A. Is there any way to do this ...
0
votes
0answers
21 views

Timestamp in iCloud Numbers?

Is it a way to display current date without writing manually in iCloud Numbers? Value should not change when opening again document. Also Copy and Paste Formula Result =now() does not fit my need. ...
0
votes
1answer
26 views

Duplicated table in Numbers

I think I have exactly the problem described here: https://discussions.apple.com/thread/250476270?answerId=250909160022#250909160022 - Numbers apparently drawing the spreadsheet on top of itself, ...
2
votes
1answer
39 views

How to read currency values in Numbers?

I have currency values in the following format in a CSV file. $171.5M $2.74B How do I have Numbers recognize these as proper currency values for sorting?
11
votes
3answers
3k views

Is there a hack for “Save As…” command?

The only thing I like about Microsoft's implementation of the Common User Architecture is the Save As... feature, which makes it easy to use cloud storage, local backups, etc. I know, I know, you can ...
0
votes
1answer
30 views

How do I record changes to a cell in Numbers via AppleScript?

I'm very new to AppleScript so bear with me. What I am trying to achieve is for every time I run the script, the current value of a cell is copied into a cell, one column to the right of when I last ...
0
votes
0answers
13 views

Pages: Long table pasted into page-layout document is truncated

I'm pasting a long table (created in Numbers) into a page layout document in Pages 8.2. The results look sort of like this (sorry for blurring out the text): I have not been able to make the table ...
0
votes
0answers
7 views

In Numbers, show data (rounding) with a given number significant figures?

In Numbers, show data (rounding) with a given number significant figures (sigfig)? Either purely visually (like it's format setting for decimal plages (dp)), or any other way, without changing the ...
0
votes
2answers
35 views

Is there a way to restore the original sorting in a Numbers table?

I have just started using Numbers and I started messing around with the organization options. Filters and categories work great, however, sorting has a weird behaviour. If I sort the rows by a given ...
1
vote
1answer
31 views

Linking between tables in different spreadsheets in Numbers

I wonder if it's possible to link tables from different spreadsheets. I have several live projects running at the same time, for each I have a "Project finance" sheet, in which I have ...
0
votes
2answers
19 views

In Numbers make Y axes show smaller values

I have a table making a line graph with very small numbers that vary from 0,000149 to 40, and when I make a line graph out of this table of numbers the very small numbers are crunched in a horizontal ...
0
votes
1answer
17 views

How to empty a cell in Numbers without formatting the cell

How do i delete all the content from a Numbers sheet without formatting the cell? Using google it says to use the delete button however it does empty all the functions and format as well. I have my ...
1
vote
1answer
24 views

How to create a Dynamic chart in Numbers to change dates based on cell [duplicate]

I would like to create a chart in Numbers that can dynamically change date ranges depending on different start and end dates set in start and end cells (or drop downs). This is for the purpose of ...
0
votes
1answer
20 views

How to swap numbers row with symbols on US keyboard?

As a programmer I’m typing the symbols on the number row more often on the keyboard than I type the numbers. Using the US keyboard layout, I have to press shift-7 for example to yield &. I’d like ...
1
vote
2answers
50 views

Capture month end values in Apple Numbers

Is there a way to capture a cell value at a specified time in Numbers. For example if you have a stock portfolio and wish to capture month end values can this be done?
1
vote
1answer
18 views

Mac Numbers: How to identify cells that match a range of cells from another table?

I have two sets of data on two sheets both including customer reference numbers, some of which match. I am trying to run a formula to identify every row in Sheet 2 where the customer reference number ...
1
vote
0answers
39 views

Formula result does not display in Numbers for Mac - Intermittent

[Note: this is not the same issue as the post entitled "Display Blank on Formula Error" so please don't mark this as duplicate for that reason.] Some cells containing formulae are not displaying, but ...
2
votes
3answers
28 views

Numbers not creating a line graph

I'm quite new to Numbers (and spreadsheets programs in general) but I need to create a simple line graph based of a spreadsheet but for some reason Numbers is not making the lines of the graph even ...
0
votes
2answers
32 views

iWork Numbers How To Calculate - In Once Cell Function - The Elapsed Time In Hours Between Two Date/Times?

Let's say I have two date/times. The start date/time is 29th May 2020 at 20:30 and the end date/time is 30th May at 02:30. This link shows how to calculate using two cell references. How to ...
1
vote
1answer
30 views

Sort Numbers spreadsheet by how many times a value appears in a column

From this image you can see I've sorted the table by column G alphabetically, but what I would like to do is isolate the rows that only have one instance of the value in the G column. Most have ...
1
vote
0answers
26 views

Numbers removes Byte-Order-Mask (BOM) from UTF-8 files when exported as CSV. How to fix?

I am dealing with a requirement where CSV should be UTF-8 encoded, in order to detect this in my java application I am relying on Byte Order Masks which is working perfectly fine but we found out that ...
1
vote
1answer
36 views

Open files in Tabs in Numbers

When I choose File > New or File > Open from Numbers menu, the file opens in a new window. How can such a file be opened in a new tab rather than in a new window? It would also be great to have the ...
0
votes
1answer
20 views

Can not reduce size of an inserted image in Numbers

I have done Insert |Image Gallery and cut and paste a single Image. I can only reduce its size a certain amount: it is still much too large. It is strange to do Image Gallery for a single image: is ...
0
votes
0answers
8 views

Update Numbers spreadsheets for multiple user versions

I'm trying to use a Numbers spreadsheet that can hold a list of items, which friends and I would then mark when we've completed the items. Basically, a simple sheet with items in column A, and Y if ...
1
vote
0answers
56 views

Get historical currency rate via CURRENCYH shows error: The requested historical date is invalid or is in the future

From Apple Number’s doc, the formula CURRENCYH should return historical currency data. Examples =CURRENCYH(“USD”, “GBP”, 3, “18/04/2017”) returns £0.78, the lowest rate of exchange (“low” or 3)...
0
votes
2answers
142 views

How to add hyperlinks to local files in Numbers?

How do I add a hyperlink to a local file? I know how to add a hyperlink to a website, so I tried something like file:///Users/MyUser/Documents/Invoices/Some%20Stuff.pdf However, adding this path to ...
1
vote
1answer
89 views

Numbers - INDIRECT Call Error

I have a spreadsheet in Apple Numbers which I use to track debts and amortize payments. To do this, I use calls to INDIRECT on the Amortization table to load relevant data from the Debts table. ...
2
votes
0answers
57 views

What's going on with Apple Numbers dates?

I have an Apple Numbers table that I've been updating since 2016. At the start, I incorrectly inputted dates such as 1-1-2009 as 1-1-9. (This is not a problem for later dates such as 1-1-10 because ...

1
2 3 4 5
12