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
1
vote
2answers
13 views

Is there a hack for “Save As”?

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 ...
0
votes
1answer
17 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
5 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
6 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
1answer
17 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
11 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
17 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
11 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
18 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
16 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
40 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?
0
votes
1answer
12 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 ...
0
votes
0answers
16 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
24 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
25 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
20 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
27 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
7 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
38 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
37 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
45 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
55 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 ...
0
votes
0answers
9 views

How to sort heterogeneous column by date?

I am aware of this question and can sort a column by dates. But my dates are heterogeneous. Meaning some are just years, others in the format 2/2020. When I apply sorting to this, the years without ...
0
votes
0answers
7 views

Path to file listed in Recent documents?

I have the same "recent document" in both Numbers' Recent documents as well as in the system wide Recent documents (in the Apple-menu) but the document is gone. I would like to see the path where ...
0
votes
0answers
9 views

Numbers: Sum the same cell across multiple sheets

I'm making a tracker for my HSA expenses. I have it organized by year, one sheet per year. Within each year I have a "Purchases" table for individual expenditures and a "Totals" table for ...
0
votes
1answer
17 views

How to set odd rows as x axis and even rows as y axis in numbers?

I am trying to create a chart using some data. The odd rows represent the date and time and even rows represent the count. I want to make the odd(date-time) rows as x-axis and even(count) rows as y-...
0
votes
0answers
28 views

Copy select cells and pasting together in Numbers (like excel did)

I'm trying to figure out how to copy select cells from one table/area in Numbers.app, and paste to another table/area where what is pasted, is in sequence (next to each other). In Excel, when you ...
1
vote
1answer
18 views

Custom Data Labels in Numbers Chart?

I have 3 columns of data that I'm using for a scatterplot. X variable, Y variable, and Year. I have the chart working properly for the data but cannot find anyway of labeling each point with the ...
0
votes
1answer
41 views

How can I sum values of a specific category over a range of dates in Numbers?

Hi I'm doing some bookkeeping for a business and one thing I have to do is add all the different transactions by category for January, then February, and so on. How do I do that in a Numbers sheet ...
0
votes
1answer
25 views

apple numbers Filling data into a table using AppleScript

I have a document on numbers with 3 sheets. 1-data entry table (based on the "data" sheet). 2-copy dada table with: -- I.an additional column containing the following formula if(reference ...
0
votes
0answers
52 views

How to insert image into Numbers with AppleScript

I'm trying to create an AppleScript that will: find the value of cell "x" tell application "Numbers" to ¬ tell table 1 of sheet 1 of document 1 set theimagename to value of cell "A8" ...
0
votes
0answers
27 views

Numbers: How to import CSV file exported with options “Combine tables into a single file” and “Include table names” and preserve Sheets and Tables?

Given this sample Numbers document: Numbers is able to preserve Sheet and Table names using the "Combine tables into a single file" and "Include table names" CSV export options: Contents of Untitled....
0
votes
1answer
94 views

numbers STOCKH function for historical stock prices

The function STOCK("WTR") in numbers 6.2.1 works well, it returns as a value today 51.94US$ and it returns also an overview window. However, when I use STOCKH("WTR",0,"29 Mar 2020") it returns "The ...
0
votes
1answer
26 views

Mac OS menu clicking slow, numbers down the side

I am running Mac OS 10.15.2. I rarely reboot my computer, but I had to turn it off to move it home due to Coronavirus, and I when I rebooted I found I had received an unwanted change. Now, whenever I ...
5
votes
1answer
125 views

How to make a scatter plot using Apple Numbers?

I'm trying to make a scatter plot in Numbers but can't get it to work. If I select column A & B and have it make a scatter plot it uses column A for both axes. If I click on the plot and go to ...
0
votes
2answers
40 views

How to get to compare one column between two sheets to tell info in one sheet that is not in the other in Numbers

What we are trying to accomplish is: 1) We have a list (spreadsheet) of all of last years clients. 2) We have a list (spreadsheet) of this years clients. 3) We need numbers to subtract out all of ...
1
vote
2answers
22 views

How can I add all of the text strings in all of the cells in a row together?

I am building a tracking sheet in Numbers for when I need to send my clients lists. I can't seem to figure out how to build a text string that contains information from all of the cells in one row. I ...
0
votes
0answers
15 views

iWorks Numbers convert forumla output to a URL [duplicate]

I wrote the following formula in numbers ="http://www.google.com?id="&$A1 It shows me the resulting string correctly. like http://www.google.com?id=1 However this is just a string and I cannot ...
1
vote
0answers
20 views

CSV import works in Numbers, but fails in Mac Excel and Mac OpenOffice Calc

If I open a CSV file in Numbers, a particularly long series of text-only cells works like a charm. If I open the same CSV file in Microsoft Excel for Mac, or OpenOffice Calc for Mac, the long cells ...
1
vote
3answers
80 views

How to sort rows in Numbers without affecting the formula?

I have a table with a basic formula: The 7th column (1038€94) is calculated with the formula 1133€34 - 94€40 + (empty cell). In others words, the 7th column is calulated by (value in the row above) - ...
1
vote
2answers
175 views

How to set a date-based x-axis in Numbers with incomplete data?

I have a simple table (date, value) and I want to display that data in a chart. This is my current chart: As you can see, I don't have a value for each day, there is about one month between the last ...
0
votes
1answer
29 views

Programmatically convert formulas to their values in Numbers

I have a couple of Numbers documents with multiple sheets each which containi quite a lot of formulas (enough to slow down most typical actions on the spreadsheets such as text input and, most ...
0
votes
1answer
289 views

Heatmap in Numbers (colouring cells by their numeric value)

In Excel, it's possible to display a "heatmap", i.e. colouring a group of cells depending on each cell's numeric value: I'm looking to do the exact same thing in Numbers, but surprisingly I couldn't ...
1
vote
1answer
38 views

How to add colors for Charts in Numbers v6

Numbers 6.2.1 limits you to six colors for a Chart, which is a problem when creating a donut chart with more than six segments. Is there a way to add colors if needed? I've found this question being ...
1
vote
1answer
109 views

Numbers formula for rolling 12 month sum

I have a table with income data over a 2 year period showing columns: date, description, job1, job2, job3, (the income shown is for 3 different work jobs over a period of time). In a separate table I ...
0
votes
2answers
37 views

Pages and Numbers have generic app icon in Dock

I have a MacBook Pro 13" Unibody Early 2011 running macOS 10.13.6 (the latest it will support). I wanted to replace the HDD with a 256GB SSD so I did a fresh install to the SSD in an enclosure then ...
1
vote
1answer
34 views

Numbers - problems with a formula for “text to columns” behavior

I have a column with three comma separated RGB values that I want separated into three columns by formula, meaning I want a sheet that lets me paste "0, 0, 0" or "0,0,0", or "255, 255, 255" etc. and ...
1
vote
2answers
68 views

Why can I not have the date and time in one cell

I want to start at a date and at 12:00:00 am and I want each cell to increase by 1 hour. I put =a2+time(1,0,0) but I keep getting "The formula’s arguments can only include one date value." What am I ...

1
2 3 4 5
12