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
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?
0
votes
1answer
13 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
27 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
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
1answer
13 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
2answers
18 views

Generate a new table entry in one sheet from another

I have a numbers file with 2 sheets: sheet1 and sheet2. On sheet1 is where I am entering some data in some cells. On sheet2 there is a transactions table with different entries. Is it possible to ...
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
32 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
33 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
2answers
1k views

How to save changes in a CSV file using Mac Numbers?

I have a .CSV file, it opens well in Numbers ~4, but when i do changes in that file (editing row color, etc) i can't correctly save it. If i try to save it as .numbers - when i open that .numbers file,...
1
vote
1answer
32 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 ...
6
votes
5answers
29k views

Insert date & time in latest version of Numbers

I've looked around online and have found references to an "Insert => Date & Time" capability in Numbers for OSX. But it's not there in my version of Numbers (3.0.1 -- 1483). Has this capability ...
0
votes
0answers
7 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
2answers
33 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 ...
0
votes
1answer
25 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, ...
6
votes
6answers
9k views

Open CSV File with Different Separator

I'm currently using the default Numbers application to open my CSVs. My current use case involves a file that I had to use a different type of separator (|). Is there any way to change the separator? ...
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
96 views

Can't find SUMIF in my Numbers functions. Could someone tell me where to find it?

For the first time I am working with Numbers rather than Mac Exel, which I was running on my old G4. I now have a 2012 MacBook Pro with Mavericks, and the one function I use more than any other is ...
4
votes
2answers
8k views

exporting numbers 09 to excel with photos in spreadsheet

When I export my numbers spreadsheet with photos in the column the photos do not transfer when I import it into excel. How can I do this?
1
vote
1answer
25 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 ...
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
4answers
764 views

Equivalent of =SUM(ABOVE) in numbers?

I have a table like this, I need to sum all fields above (exclude the header), the following formula works: =SUM(C1:C5) When I add more rows I must rewrite the formula, then I tried something like ...
0
votes
1answer
14 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 ...
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 ...
2
votes
1answer
651 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 ...
0
votes
0answers
10 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
2answers
40 views

How can I convert US-format date and time into a date value so I can use the local date format?

I am in Australia and use the default date formats here (dd/mm/yyyy). Unfortunately, BandCamp exports sales data using a US date format: "m/d/yy h:mmpm". For the most part, Numbers treats this as text ...
1
vote
2answers
46 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
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
67 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 ...
7
votes
3answers
54k views

Old version (macOS Sierra) for Pages, Keynote and Numbers, iWork

I uninstalled my iWork tools - Keynote, Numbers and Pages - from my MacBook Air. Unfortunately, I don't want to upgrade my MBA to Mojave/Catalina in order to install. I looking for the working iWork ...
4
votes
10answers
14k 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 ...
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 ...
1
vote
1answer
4k views

macOS Sierra / Numbers 4.0: Problem with saving on a Synology via AFP

I updated my Mac to 10.12 Sierra and updated Pages, Numbers and Keynote afterwards to the latest versions. So far so good, everything running normal. But unfortunately saving a Numbers file via AFP ...
1
vote
1answer
23 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 ...
2
votes
1answer
1k views

Charts from numbers not dynamically updating in Pages/Keynote

I have the 2015 versions of Pages, Numbers, and Keynote on Yosemite. I created a chart in numbers and then copied it to Pages or Keynote. I then want to be able to change the data in Numbers and see ...
1
vote
0answers
29 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 ...
0
votes
1answer
19 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
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 ...
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 ...
1
vote
3answers
153 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) - ...
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
29 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
25 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 ...
2
votes
5answers
5k views

How to open numbers spreadsheet in 2 separate windows

I often find it useful to have two tabs of one spreadsheet open in separate windows. In Excel this is easy (Windows/New Window). Is there any way to achieve this in Numbers (as of Version 3.5)? For ...
1
vote
1answer
33 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 ...

1
2 3 4 5
12