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
3
votes
1answer
700 views

How do I create a secondary X axis in numbers?

So I have a set of data such that: "Months A/B/C" represent X values, and Cost represents the associated Y value. Combined, there is the data there to plot three different data series on this one ...
2
votes
1answer
7k views

Numbers for OS X Yosemite 10.10.5

I need Numbers for OS X Yosemite. When I try to install from the Apple store, it only gives the option for 4.1. I think I need 3.2.2 or around there. When I try to install 4.1 it complains: I cannot ...
2
votes
4answers
11k views

Batch convert Apple Pages files to Microsoft Word doc files

How can I convert a large number of Pages and Numbers files into corresponding MS Office format in a quick manner.
8
votes
4answers
24k views

How to change the colors of individual bars in Numbers 3.2

How do I change the colors of individual bars, in a bar chart of in Apple's Numbers 3.2.x
1
vote
2answers
2k views

Converting a float to hours:minutes in Numbers

Probably this is a very easy thing to do, but as handicapped as I am using Apple's iWork applications, I just can't find it. I have made a calculation in Numbers which results for example in 14,25 or ...
2
votes
1answer
5k views

In Numbers, how can I show a formula instead of the result?

I want selected cells to show the formula instead of the result of the formula, for example cells C4 and D4 here. If the cell is formatted as text before I enter the formula, then the formula remains ...
2
votes
1answer
17 views

Increase numbers by one in merged cells

My question is very related to this https://discussions.apple.com/thread/3204532. I just want to do the same but in merged cells, as in the picture below. Is it possible? I see no fill handle here.
2
votes
1answer
608 views

Unable to open CSV file

I have a reasonably sized CSV file (40 Megabytes). I know that some apps won't work with certain encodings, and that they will throw error if the encoding isn't ASCII. But its alarming that even ...
2
votes
2answers
7k views

How do I insert a row into numbers, in just one column

How do I insert a row in one column only. By moving the current data down and inserting a row above it. I don't want to insert a row across the entire spreadsheet - just that column.
0
votes
1answer
26 views

Information on Box

updates for Numbers, Pages, and Keynote say that you can do collaborative work using Box. What do we know about this "Box"? Searching such a short word on Apple's site seems hopeless.
2
votes
1answer
34 views

Shortcut to Bottom border in Numbers

Here there are many shortcuts for Numbers https://support.apple.com/kb/PH23737?locale=en_US&viewlocale=en_US. I would like to have one for Borrom border. I tried (without success) the following: ...
1
vote
2answers
335 views

Open AppleWorks spreadsheets in Mac OS X when Numbers won't work

I have a number of old AppleWorks spreadsheets that I'm trying to open. I've tried a number of solutions that I've found while searching for an answer (below), but none of them really get me to where ...
4
votes
1answer
10k views

Deleting formula sources without destroying formula output, using Numbers for Mac

I would like to delete the source column for a formula in Numbers 3.2.2, without destroying values in the formula's output column. Specifically, I have a column of "Last, First" names, which I parse ...
0
votes
1answer
513 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,...
0
votes
2answers
151 views

AppleScript export variable to Numbers / Excel / SQL

I would like AppleScript to add a new row on a number or excel sheet (or on a SQL database) I have my data saved on a .plist which I can retrieve with set myDateFromPlist to value of property list ...
2
votes
1answer
52 views

Apple Numbers : countif and stats

I have a sheet with a few columns, Columns A contain dates, Columns T contain some text What function can I use to count : The numbers of result in the columns A which match the current day I ...
0
votes
1answer
50 views

Create a table from other table depending on a value NUMBERS

I have a table with a list of items, and I want to create a new table with all the values that contains a certain value. In the first list, are all the profucts that I usually buy and a cell with "...
3
votes
2answers
891 views

Any way to use a VLOOKUP formula in Numbers to insert an image instead of text value?

The intent is to create a sheet that references orders from customers with an image of each item ordered from my catalog of inventory. I need to create a spreadsheet that references item SKUs to ...
1
vote
1answer
52 views

Reference image in Numbers?

I have found that I can add images to cells as background in Numbers in various sheets. I'd like to reference these images in these cells from another sheet. Is this possible?
0
votes
2answers
383 views

Using last column in Numbers

I would like to subtract the last column of a specific row. Since the number of columns is always changing, I need to get it dynamically. I figured there is a function that gives you the number of ...
0
votes
0answers
205 views

iCloud Drive: My files can't be found on my iPad

I have 200go on my iCloudDrive and all my Documents folder is on the cloud. On my iPad, with the Files app, I am able to browse in the folder hierarchy in Documents but ultimately the folders are not ...
1
vote
2answers
378 views

Text substitution and change cell background colour. Numbers & AppleScript

I am working with Numbers spreadsheet files whose final output must be in German. The source of the data is the Apple Configurator app (via Automator), which produces everything in English despite the ...
2
votes
3answers
29k views

How to import a spreadsheet into Numbers from an email attachment?

I want to know how to open a spreadheet email attachement in the Numbers app on the iPad. Here are the steps I have taken with no luck: On the iPad I open my email. I see a spreadsheet attachment. I ...
0
votes
1answer
116 views

Open text file in Numbers when it is space delimited, but some fields are strings in quotes with spaces

I have a log file I'd like to open in Numbers to make sifting through it a lot easier. The problem is that the format isn't CSV. Each line has about a dozen fields, and the fields themselves are ...
2
votes
1answer
1k views

Split a column in Numbers by extracting text in parenthesis

I need to extract everything from "ORIGINAL COMBINED" that is between parenthesis and place it in the SPLIT A and place the remainder in the SPLIT B column. For example:
1
vote
1answer
1k views

Concatenate & VLOOKUP

In Numbers, I'm trying to enhance a Concatenated formula of multiple VLOOKUP results. I'm currently producing a result of three concatenated answers (each a specific VLOOKUP formula). I would like to ...
0
votes
0answers
24 views

Import dates from Excel to Numbers?

I'm trying to move to Numbers instead of Excel for basic sheet stuff, as Excel is a pain in the ass to use on Mac. I'm trying to have some dates to look like dates and apply conditional formatting. ...
1
vote
2answers
45 views

Numbers if cell is equal to X or Y

Is it possible to test a cell using IF against multiple strings? So for example, I want the function to output Fruit in cell A2 if cell A1 contains the string Apple or Orange. I can only come up with ...
0
votes
2answers
5k views

Apple Numbers: how to change a date format to a number format

In Apple Numbers the app can work out the number of days between dates, but then if I times this by a number (ie, a %interest rate and an amount of money) Numbers insists that the answer is a number ...
1
vote
1answer
190 views

How to convert a cell with a duration (datetime difference) to number in Numbers?

I have four fields in Numbers on macOS: F1: datetime F2: datetime F3: duration F4: number The dateime-fieds contain only a time, like: 10:00 11:00 11:00 12:30 13:00 13:15 The duration-...
6
votes
2answers
109 views

In Numbers can you auto-populate a cell with a date when another cell is populated?

I'm an avid Excel user and recently I've had to figure out how to use Numbers. So far I've been able to replicate all the Excel functionality that I use in Numbers... except for one thing. In Excel ...
1
vote
0answers
36 views

two tables, one chart (x-axis is time)

I have two tables such as Var_A Var_B 5. Jan 2017 33.3 2.22 5. Jun 2017 44.44 3.33 Var_A Var_B 5. Feb 2016 22.2 5.55 5. Jul 2016 27.2 4.44 and I would like to ...
2
votes
1answer
57 views

entering data in Numbers

When I hit Return after entering a number in a cell, the cursor automatically drops down to the next row under the cell. How can I disable that, so it stays on the cell I entered and I can move on my ...
4
votes
1answer
96 views

Numbers fill color

In Numbers is there a way to set a fill color to repeatedly select for random cells, such as in Excel? I am not looking for a conditional formatting. I would like to color fill any cell I choose ...
0
votes
1answer
26 views

How to edit shared iCloud note in native app?

I shared an iCloud note with somebody else to work on it together. I sent a link via E-Mail which points to iCloud.com. The other person opens the link, signs into iCloud and then the note is opened ...
5
votes
2answers
2k views

SUMIF statement with two different conditions (Text based and checkbox)

How can I create a SUMIF statement with multiple criteria? I have a spreadsheets where I track hours for different clients in one table, and below this table I want to summarize in a summary table ...
2
votes
1answer
91 views

Calculating a custom total for a column on iPad mini and Numbers

How do I make a formula to total (sum) a column using Numbers on iOS, but exclude negative numbers? (Only sum positive numbers) Example: +-------+ | LIST | +-------+ | 1| | 2| | 3| |...
0
votes
1answer
6k views

How do I plot two data streams in Numbers as a graph?

I have two different streams of fractional values I want to visualize using Numbers for Mac. They both have one value per line and both look would look something like this (with different values ...
1
vote
1answer
668 views

Is there a way to put images in cells in tables in iOS Numbers? 3.2

Is there a way to put images in cells in tables in Numbers iOS version 3.2? I've looked at the Apple help and it only shows help for on the Mac and putting an image for a cell background. I'm using ...
1
vote
1answer
212 views

Numbers: Find a cell in a table (lookup) using multiple criteria

I'm using Numbers '09 (but can upgrade if need be). How can I find a value using multiple criteria? Let's say I have a table of flights, with columns for the flight date, flight number (including ...
3
votes
1answer
550 views

Numbers Lookup Finding incorrect values

I have many tables with two columns (key-value style) and I want to combine all the values in a single table. I lookup key in a first column and insert a value from the second one. I've encountered an ...
3
votes
0answers
729 views

AppleScript and Numbers: Copying from one spreadsheet to another?

I'm new to AppleScript, and I'm trying to find a way to use it to copy a value from one Numbers spreadsheet and paste it into another file. The situation is that I've been using Numbers to run a ...
1
vote
2answers
849 views

Numbers: How to prevent Numbers from changing currency automatically?

I have a spreadsheet that has cells with two currencies. USD & EUR. I have a cell that is a USD formatted cell. I now have a EUR cell that is based on a multiplication of the USD formatted cell ...
0
votes
1answer
6k views

How to see page breaks in Numbers version 3.x

In my old version of Numbers, I could see the page break (both at the bottom of the page, and on the side) so I would know when I needed to add a row or column. I can't seem to be able to see the page ...
4
votes
1answer
17k views

How to change cell background color in numbers according to some rules?

Making it simple, using Numbers, how can you set up the following: If number is positive make background cell green, else make it red.
2
votes
1answer
600 views

set checkbox based on parameters in iWork Numbers

I would like to be able to tick or untick a checkbox in iWork Numbers based on certain parameters. The spreadsheet is a list of projects (Column C), each composed of several tasks (column D). Column ...
3
votes
1answer
3k views

How to export only the selected part of my Numbers file to PDF?

I have a Numbers file which has a lot of elements that when I want to export it to PDF it becomes 12 pages of A4 size. All I want is selecting part of it and exporting only that part to PDF. Is it ...
3
votes
1answer
187 views

Count number of text occurrences in column using Numbers

I am using Numbers to track data. I have a column that has comma separated values within each row (e.g. ‘I like cats, I hate rain, I like dogs’). Is it possible to count the number of appearances for ...
1
vote
2answers
427 views

If reference cell contains “x”, return “y”, otherwise return “z”

I'm trying to build what seems like a dang simple formula, but for some reason it's stumping me. Here's the idea: IF(//B4 contains "apple"//),"$100","$200") so that it returns "$100" if B4 contains "...
2
votes
1answer
139 views

“Glitched” pixels, El Capitan, formula box in numbers

Today I installed El Capitan on my Macbook Pro and noticed some weird graphical effects when I was editing my numbers document: I know that this is entirely software-related, otherwise the screen ...