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
2
votes
1answer
2k views

Open new Numbers document in older Numbers

I have a Numbers (v3.5) file from a Yosemite install. I have since abandoned Yosemite (here is why WindowServer high CPU on Yosemite). Now I cannot open this file in Mavericks' Numbers (v2.3) app. I ...
0
votes
2answers
32 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
25 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
1answer
29 views

How to remove all cell formatting

How can all formatting be removed from a sheet in Numbers so each cell only contains the text, with links no longer clickable?
0
votes
2answers
54 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 ...
0
votes
1answer
33 views

Regarding AppleScript, is it possible to change “page layout” export option when exporting Numbers documents to PDF?

A little while ago I cobbled together a short AppleScript for exporting multiple Pages documents to PDF at one time, and now I want to do the same with Numbers. The basic principle is the same and the ...
2
votes
1answer
658 views

How to export a table with transparency from Numbers to PNG?

If I copy a table from Numbers to the pasteboard and then create a new document in Preview, it usually works fine, but if cells contain partially transparent background or border colors (especially ...
2
votes
2answers
2k 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 ...
0
votes
1answer
67 views

AppleScript tell Numbers make Pop-Up Menu from Contacts Group names, wait for input, then Email ScreenCapture

This is a bit long-winded, but here goes… Using AppleScript (vanilla, please), I want to automate the Numbers spreadsheet I made for my wife’s music lessons Accounts (which she uses four times a ...
2
votes
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 ...
0
votes
0answers
17 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 ...
0
votes
0answers
29 views

How can I print comments in Numbers?

I have a Numbers document containing several comments. I'd like to include these comments when printing the document — or creating a PDF — but I cannot locate an option to do this. I've searched ...
1
vote
1answer
44 views

How can I see the list of recent opened files in Numbers?

How can I see the list of recent opened files in Numbers? Is this supported at all?
1
vote
1answer
60 views

Sum of VLookups in Numbers?

I may just be missing the right terminology, spreadsheets have never really been my thing. But I'm struggling to combine SUM() and VLOOKUP() for my needs. (Assuming these are even the functions I ...
1
vote
1answer
110 views

Batch exporting metadata from Finder

I have a folder containing over 2,000 web pages I've downloaded. Most of the file extensions are .html, though some are .pdf or .webarchive. My OS is Mojave. When I highlight an icon in Finder, it ...
0
votes
0answers
21 views

Change line color of line chart in Numbers dynamically depending on value

I have created a line chart in Numbers: I would like the line color to change when the values lie below a certain value (e.g. 0): The values are calculated dynamically and change continuously when ...
1
vote
1answer
19 views

Numbers.app force me to download Chinese fonts but the download always fails

Whenever I open the Numbers app the pop up always shows up, requiring me to download Chinese fonts. The dialog reads "Numbers.app needs to download the font. The size is 50MB.". However, when I ...
0
votes
1answer
33 views

Draw a Pie and Bar Chart in Numbers

Hello I am trying to learn numbers. I have this table | ------- | ----------- | | Person | Status | | ------- | ----------- | | John | Not Started | | ------- | ----------- | | Gary | ...
0
votes
0answers
1k views

How to set a custom page size in Numbers?

There seems to be no option for this on Numbers 4.2 There are a bunch of options with fixed sizes, but nothing to set custom values for the document's width and height. The reason is that I want to ...
1
vote
1answer
59 views

iMessage checker

I'm trying to do a number checker in imessage. We all know that there is no such api, so I'm trying to use the tools at hand. The main took with past issues on this site on this topic. I made a ...
0
votes
1answer
37 views

Automatic export to .csv when saving .numbers

For now my workflow is: opening myfile.csv in numbers applying changes to myfile.numbers saving myfile.numbers export myfile.numbers to myfile.csv (overwrite old) Rinse - repeat when new changes ...
1
vote
1answer
55 views

iCloud is not syncing files within Pages and Numbers folders

Ever since I upgraded to Catalina, I've had a problem where the files within the Pages and Numbers folders in iCLoud don't sync to my Mac, except for files I've created since the upgrade. However, if ...
2
votes
1answer
22 views

Can I use a formula as a Table Name?

I would like to have a table name automatically generate when a root value is updated. For example, in my budget spreadsheet, I have Groceries 11/07 -> 11/06. In a cell, if I have a cell starting ...
2
votes
1answer
53 views

How to prevent displaying the total sum of A + B if columns A + B are empty

I have inserted a running total formula in my numbers sheet. It sums the total of Column H, which works fine. However when cells in columns H are empty it will display the last sum, which I do not ...
3
votes
1answer
21 views

Can I reference a hundreds value of a number from a cell in Apple Numbers?

For example, A1 has 12,345.00 I want A2 to output 345.00. Is this possible?
6
votes
4answers
7k 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? ...
14
votes
2answers
29k views

Is there a way in Numbers to flip columns with rows?

Is there a way in Numbers to flip columns with rows ? I have several tables in my sheet and I need to swap columns with rows for each table. e.g. A1 A2 A3 B1 B2 B3 C1 C2 C3 should become: ...
1
vote
1answer
31 views

Numbers uninstall reinstall

Lately Numbers has been quitting unexpectedly on my MacBook Air and all the pre-installed templates are gone. Also it quits when working on formulas. I'm thinking I could store documents in the cloud ...
2
votes
1answer
46 views

AppleScript Numbers Retreiving Cell Value

I have a script which loads a Numbers document in order to retrieve a specific cell value to use in creating a reminder. My code is below. I believe I'm using correct syntax to load the value into a ...
1
vote
1answer
122 views

AppleScript Opening iCloud Documents

I am trying to write an AppleScript to open a Numbers document, which is stored in the Numbers folder on my iCloud drive, so that I can access a cell value and create a reminder with it (or otherwise ...
0
votes
0answers
10 views

Matching multiple text strings with sumifs

I have a formula where I'm using sumifs to match several conditions in each row on a table. For the sake of simplicity, I'm reducing this example down to just the one condition I'm having a hard time ...
1
vote
1answer
36 views

Get the next date from column of dates

I have a table in Numbers with a column which contains dates. From that column, I'm trying to get the next date from today from that list and display it in a cell. Assuming today is October 12, 2019, ...
73
votes
3answers
25k views

Why does Numbers hide a huge PNG file in exported Excel sheets?

OK, this is a weird one. I take my blank Numbers sheet: ...and export it to Excel: Whoah, that seems a little large. Let's rename the Excel doc to .zip and have a look inside: Digging a little ...
2
votes
2answers
1k views

How to prevent Numbers from changing currency automatically

I have a spreadsheet that has cells with two currencies: USD and EUR. I have a cell that is a USD formatted cell and the other, a EUR cell. The EUR cell values are results of the multiplication of ...
3
votes
1answer
5k views

Merge Spreadsheets

[Numbers, macOS] I need to merge data in 2 spreadsheets / tables. Both of them contain contact information. The second table contains a column that I want to append to the first table. Now, I can't ...
2
votes
2answers
1k 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, ...
2
votes
0answers
35 views

Select all next non-empty cells in Numbers

Is there a way to select all next non-empty cells? as in pressing Shift+Ctrl+Arrow Key in Excel app For example, I'm now at A1 and A5 is empty. ▼ By what means I can select A1 to A4 by one key ...
8
votes
1answer
852 views

Numbers shortcut to jump to next non-empty cell

I have just purchased my first Mac and am having problems with Numbers. I want to jump to the next cell in a given direction that is non-empty (or jump to the end of a contiguous chunk of cells that ...
1
vote
1answer
64 views

How to format a cell with data YYYYMMDD in Numbers to be a date type?

I created a custom format to try and format a date column to be used within categories. However, Numbers tend to keep reverting my custom format to "Automatic" and I'm unable to group the data as part ...
2
votes
1answer
19 views

How can I autofill a formula in Numbers, but keep some referenced values the same?

So I have a chart in Numbers (iOS version, but I can use the macOS version, if needed,) which has formula that references some values from the chart, as well as some values from a different chart. I ...
0
votes
3answers
87 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 ...
2
votes
1answer
56 views

In numbers or pages for ios, Is it possible to force a trend line to start at (0,0)?

I was wondering, if, in whatever the newest version of ios, numbers, and/or pages, it is possible to force a trendline through a point on a 2D scatter graph (e.g. the origin (0,0)). I was hoping to ...
0
votes
1answer
153 views

Copy and paste issue from Excel to Keynote table

I'm having a big issue when copying from multiple Excel cells/rows and then pasting into a Keynote/Numbers table. When I select multiple cells in Excel with named content such as 'David goes to the ...
4
votes
2answers
672 views

Can I create something like a macro in Numbers?

I have this long formula that is used in a lot of columns: =SE(N17<60; DEF.NÚM.DEC(SOMA(60; −N17); 1); "✔︎ Aprovado") So, when I need to change something in this formula, I need to edit each one ...
2
votes
1answer
102 views

Applescripting Numbers to save, close and quit in an App instead of the Script Editor

After using Applescript to add a new row with data to a Numbers document, I'm trying to save and close the document and then quit Numbers. Using the script below to save, close and quit Numbers works ...
0
votes
0answers
156 views

How to disable updates notification on iPhone XR (iOS 12.4), such as for an update of Numbers?

I'm using iOS 12.4 on an iPhone XR. Toggling to "off" at Settings | iTunes & App Stores | Automatic Downloads | Updates does not prevent me from getting notifications that updates are available ...
8
votes
4answers
43k views

How can I use a secondary axis in Numbers?

One of my main problems with Numbers is the fact that it has much less of the functionality of Excel. That's why I barely use Numbers. One of the main things that I always thought impossible was ...
3
votes
1answer
98 views

Numbers: menu or list to jump to a specific sheet?

Is there a way to access a menu or list of all the sheets in a Numbers document, so I can quickly jump to one specific sheet without having to scroll or page one-by-one with the previous/next keyboard ...
1
vote
1answer
178 views

How to have Farsi/Persian font in a single column of Numbers

I've got a spreadsheet in Numbers which was a .xlsx file previously. In Windows I used to have one the columns of this spreadsheet to be shown in a Farsi/Persian/Iranian font. This column is only ...
1
vote
1answer
234 views

Help with AppleScript to automate Numbers Cell Formatting

I do several mundane repetitive tasks using Numbers App on a Mac, and wish I could just automate the same with the help of AppleScript. I got Numbers Spreadsheet with several tables, on the selected ...

1 2 3 4 5 11