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
27
votes
5answers
86k views

How can I do text-to-columns in Numbers?

I've got a column where each cell in the column contains two different pieces of data separated by a known delimiter ", ". How can I split each cell in this column around the delimiter? Given: ...
9
votes
3answers
8k views

How do I keep Numbers from mangling numbers when importing a CSV?

When I open a CSV file in Numbers, it "helpfully" converts fields it recognizes as numeric by stripping leading zeros, converting things it recognizes as dates, etc. Take for example, you type a UPC ...
2
votes
1answer
18k views

Get Numbers & Pages et al. on macOS 10.11 El Capitan

I have some old macs which cannot update to OSX 10.12, however this is the minimum requirement for installing those applications from the app store. Please could someone advise how to get an older, ...
1
vote
1answer
89 views

Naming a Cell in Numbers

Can you define a cell's name in Numbers for use in formulas across a workbook like you can in Excel?
1
vote
0answers
14 views

How does one separate a Numbers spreadsheet with multiple (4) tabs into separate files?

I have been given a spreadsheet with 4 separate tabs/sheets. I would like to separate them into different files. I know that I can cut-and-paste and create new files but is there a simpler/easier way ...
5
votes
2answers
3k views

Time as x-axis in chart with Apple Numbers

I'm trying to make an area chart in Apple Numbers (on Mac) where I have a series of values I want to plot on y-axis against time on the x-axis. Each value has a date that it occurred but the dates ...
1
vote
0answers
10 views

Keep a Numbers chart stationary while scrolling the page?

In Numbers, is there a way to make a chart stay visible at the top of the page while I scroll down through the rest of the page's contents? Similar to how a table's header row can be made to stay ...
1
vote
1answer
320 views

Numbers: hotkeys to choose cells in formula edit mode

When I edit formulae in Numbers, is it possible to select nearby cells using the cursor keys? For example, I might be editing cell C3, and set its formula to "=B2+C2". I would like to select cells B2 ...
1
vote
1answer
297 views

Get values from Numbers.app into AppleScript's variables

I have a .numbers file in following format: Product Quantity Price Apple 5 3 Banana 7 2 Orange 3 4 I need to get three variables with new-line separated values, e.g. ...
1
vote
1answer
23 views

Numbers version 5.3(5989). How to Calculate Duration by comparing two cells formatted as datetime?

Column A has been formatted in the “datetime” format. Date and time from my glucose meter were entered into Column A and displays as in the default option I selected. Column D is the glucose readings ...
1
vote
1answer
25 views

Unmerge all cells in Numbers xls file

In this situation I have 2 cells merged into 1. How can I unmerge it so the result will be 2 cells with the same data? I have cases with up to 7 cells merged in the xls file. How can I unmerge them ...
0
votes
0answers
22 views

How can I set a file password for a Numbers file with AppleScript?

Is it possible to activate the password protection (that is available in the file menu, like described here) of a Numbers file via AppleScript? And if yes, how? As an alternative: could this be done ...
0
votes
1answer
28 views

Numbers help me work out my gas consumption

Trying hard to work out my yearly gas and electricity consumption. I have forumla for SUMIF: =SUMIF (B,"="&F6,Gas Reading) But I think I want to do (IF the year is 2015 [F6 entry], then find ...
2
votes
1answer
514 views

Prevent Safari from transforming downloaded CSV files to Numbers files

On a computer that has Numbers installed, downloading a CSV file will automatically be converted to a Numbers spreadsheet and no longer be a plain CSV (not just the extension, but the contents ...
0
votes
0answers
24 views

Not able to add column in Numbers

I created a table in Numbers. Please see below picture. Strangely, I am not able to add/insert column. As you can see, Add Column Before & Add Column After options are greyed out. Could someone ...
0
votes
0answers
46 views

Conditional Formatting for Numbers forms in iOS

I've been tasked with setting up a data entry form in Numbers on an iPad where cells in the sheet have conditional formatting, but it is desired to have the same formatting applied to the linked form. ...
1
vote
2answers
769 views

The index.xml file is missing

I like using numbers 2.2 but also have 4.3.1 installed. I would much rather use 2.2. as its been working all along and because I like the format bar which is not in 4.3.1. I've been using "Open With"...
0
votes
1answer
51 views

Numbers not sorting dates correctly

I cannot get the column to sort the dates correctly in Numbers! I want to sort the column by date and instead of sorting 1 through 12, it sorts like this: 1,10,11,12,2,3
2
votes
1answer
13k views

How to sort column by date in Numbers?

I've my column in format dd/mm/yyyy and I would like to sort them by date. But I can't find any way of sorting the column by date. If I Sort Ascending, it doesn't recognise that the rows have the date ...
0
votes
2answers
117 views

Transfer formula result from one tab to another on iCloud Numbers

On Numbers for iCloud, how do I transfer a formula result from one cell to another on a different tab, but in the same spreadsheet?
0
votes
0answers
18 views

Mac Numbers equivalent to Microsoft Excel's Control+Arrow Keyboard Shortcut

Is there a feature in the MacOS Numbers application that allows me to jump to non-empty cells? In Excel if I hold the control key and press any of the keys ←↑→ or ↓ the cursor will navigate to the ...
1
vote
1answer
28 views

Numbers for macOS: how to update a column of entries

In Numbers for macOS I have a column of entries, each entry (field) is just a single word. How can I update the whole column such that each entry will look like that instead: <img src="...
0
votes
0answers
32 views

Numbers function that returns the location for the current cell

It appears that Numbers does not have user defined functions so I am writing a rather complicated expression in Emacs and then pasting it into the cell to use as an equation. I'd like to reference in ...
1
vote
0answers
11 views

Is there a function in numbers that allows to select elements that have an index congruent to 2 modulo 3 for its row, from a given column?

I want to select and do the average of one every 3 numbers and the row index of the first is 5. So I want to select 5,8,11 etc Is there a way to do it in Numbers?
0
votes
1answer
472 views

Numbers: how to search only within a selected range?

I have a very big table, and searching for a string can take a few seconds. However, I only want to search in a particular column. Even when a column is selected, Numbers searches the entire table. ...
0
votes
1answer
75 views

Is there a way to reverse the order of rows in a chart?

I'd like to change this chart to the following one: So, I'd like to reverse the order of rows. According to an answer on a similar question, you need to create a formula and put it in each cell ...
1
vote
0answers
10 views

Have an X-axis per year in a Numbers 2D-line chart

I have a sheet in Numbers where I once a week input the current reading from our electricity meter like below: | Date | Reading | | per day | |------------|------------|-------...
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 ...
1
vote
0answers
29 views

Is it possible to “lock” and prevent adding new columns in Numbers?

Is it possible to lock the number of columns in a Numbers sheet so that no new columns are added on the right when tabbing through cells? The problem is when I tab through cells from left to right, ...
2
votes
1answer
46 views

Can I use variable in Numbers cell formula?

I have to write a complex formula like this: IF(5−SUM(C35:I35)>0,5−SUM(C35:I35),"") Can I define a variable for 5−SUM(C35:I35)?
2
votes
0answers
27 views

How do I check if a date is between 2 dates?

In the above example, how would I get the “period” (column C of the Example table) of a certain date (column B of the Example 2 table) using the start and end dates (columns A and B of the Example ...
0
votes
1answer
27 views

How do I reference a cell from within a “…IF”-type function condition string?

When using a ...IF type of function (like COUNTIF, AVERAGEIF, etc.), I use condition strings: e.g. ">100", "=Mr. Smith" Instead of using a literal from within the string, how do I (or can I) ...
1
vote
0answers
476 views

Numbers - “the index.xml file is missing” [closed]

I am running OS X Yosemite on my Mac 10.10.5. I have Numbers files saved. When I try to open them, I get "The index.xml file is missing." How do I open these files?
3
votes
3answers
45k views

How do I start rows with 0 (not 1) or not count header rows in Numbers?

I'm using the Numbers app to make a database or catalogue of stuff. For example, a list of all wines I'll try this year. And for each column, I'll have the name of the wine, a rating, the kind of ...
2
votes
0answers
19 views

Paste a formula in numbers 4.2 without altering format of recipient cell

How do i paste a formula in numbers 4.2 without altering format of the target cell? I’m sure this used to be easy, but can't seem to do it. I want to paste a formula from a colour filled cell to a ...
2
votes
1answer
199 views

Numbers error: not enough space in iCloud

I recently maxed out my iCloud storage for a few weeks, meaning things like backups and photo uploading would not work. Eventually, I deleted some unwanted files, and now there is plenty of free space ...
0
votes
1answer
73 views

How can I find duplicate adjacent cells in Numbers?

I have a Numbers sheet that is thousands of rows long. As an example in the image, the sheet has two columns with URLs. What I need to do is find the rows that have the same URL in the two adjacent ...
1
vote
0answers
7 views

Is there any way to make a dynamic line chart?

I am visualizing my net worth monthly since 2014 on a line chart, but since 2017 a certain asset class has been moving exponentially and now the data from 2014 to 2016 looks like a straight horizontal ...
0
votes
1answer
29 views

Numbers - Perform arithmetic on a section of cells

I have a column of cells and I want to do 41 - (value of cell) for each individual cell without having to go through doing it manually. I know this seems simple but I can't think of an easy and quick ...
2
votes
1answer
36 views

Is there a formulaic way to reverse the order of a list in Apple Numbers?

For example I have a list of numbers in a column. I would like to have another column that takes whatever is in that list and reverses the order the list appears. Is there a way of doing this with a ...
1
vote
0answers
11 views

Comparing times in Apple Numbers

I am using the latest version of Apple Numbers on iOS. I have a table with a Date/Time column, with values being: =TIME(0,0,0) =TIME(0,30,0) =TIME(1,0,0) and so on, in half-hour increments, for the ...
2
votes
2answers
255 views

How can I make calculations based on smart category summaries in Numbers?

The latest version of Numbers has a great feature called Smart Categories that are kind of like Excel's pivot tables. I'm using it to group a table by a label and then sum up spending and revenue ...
1
vote
1answer
2k views

Hide sheets in Numbers?

Is there any way to hide sheets in Numbers? (like in Excel) I have tried everything other than delete, since I may need to refer back to them.
5
votes
3answers
5k 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
15 views

Numbers : Chart and Percentage

My question is probably ridiculous but I have to admit, I'm lost : I created a Numbers sheet for some electricity bill data. I try to get the percentage of use of the night meter so I did ...
1
vote
1answer
927 views

Is there a way to import stopwatch data into Numbers?

I use the stopwatch app to collect data sometimes, and often I'll have ~100 datapoints. (as an example, my light creaks periodically after I turn it off after leaving it on for a long time, so I timed ...
5
votes
4answers
22k views

How to convert .number file to any of the readble format including excel and pdf without having mac

I have an important .number iworks file. My Mac is now no more... How do I convert .number file to any of the readble format including excel and pdf without having mac.
3
votes
2answers
21k views

Separate multiple comma separated values in Numbers

One of the CSV files I'm using has lumped the address into one single cell, separated by commas. For example: 12 Fairy Tale Lane, Wonderland, Oz, Neverland I need to separate these into Address 1, ...
1
vote
1answer
815 views

How do I change the sheet color in Numbers 3.x?

Right now the sheet color is white. But it is hard on my eyes. How do I change the sheet color to black? I'm using a Numbers 3.x in OSx 10.9.3
1
vote
0answers
9 views

Formatting of negative currency values in Numbers

For some reason Numbers insists on formatting a negative value in a "currency cell" as € 10.99- instead of for example € -10.99. I have tried messing around with the settings in the Language and ...