A spreadsheet application developed by Apple as part of its iWork suite. The iWork equivalent of Microsoft Office Excel.

learn more… | top users | synonyms

1
vote
1answer
15 views

Can I create a formula to provide a value depending on when a timestamp falls in the day?

In column A, I have timestamp values. In a second column, I'd like to have a formula that would return words or strings like "early morning" or "Late afternoon", so that I may count and chart these ...
0
votes
2answers
2k views

How do I delete one of my custom templates in Numbers - OS 10.10.1

I would like to delete one of my custom templates I made in Numbers - in previous OS versions you went to Library>iWork>Numbers>Templates and just trash it - but, since I updated to Yosemite - I only ...
0
votes
0answers
7 views

Automate Safari form filling

I have a Numbers spreadsheet with lots of data (currently at 275 rows, 14 columns each). I need to submit this data to a web form, one row per form submission, each column going into a text box on ...
2
votes
1answer
1k views

Greyed out Hide Column command

In iWork Numbers, why is the command Hide Column greyed out? What format do I have set up that does not allow me to hide that specific column? I have un-merged all the cells.
0
votes
0answers
13 views

iCloud numbers reference date/value from another table

I am trying to create a daily budget tracker with separate tables for each month, which I have created. I now want a front/first table to show: the balance as at today's date the amount spent today ...
3
votes
2answers
324 views

Numbers: Make numbers negative

In Numbers, how can I convert a number to negative. E.g. 200 233 186 Becomes -200 -233 -186 In Excel, you can use tools like Paste Special, but these don't exist in Numbers.
0
votes
0answers
11 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 ...
2
votes
6answers
2k views

OSX Numbers 3.2 inserting date / time

I want a cell to take on the date and time of "this moment", and then leave it. Contrary to some experiences I've read about, the Insert menu does have Date & Time, but it doesn't seem to respect ...
0
votes
0answers
8 views

OSC Yosemite Numbers: conditional sum based on text of cell [duplicate]

I saw this answered for iWork a good few years ago but the work round doesn't now. I used this a lot in Excel and need it in Numbers. Help much appreciated. My query is exactly as the first time it ...
3
votes
2answers
44 views

The SUM function in Numbers 3.6.1 on my Mac OS X10.10.5 isn't calculating correctly. Why?

You can see in the attached screenshot that I have used the SUM function to add the values in column E. There are several "1" values (you can see one in cell E126) but the SUM always comes out at ...
0
votes
0answers
11 views

Numbers: How to merge multiple sheets of products into one sheet, automatically update on change of data

What i'm trying to achieve is a database for food products split into three categories:- Frozen, Ambient and Chilled. Each category is on a separate sheet which is the data and in each category it ...
1
vote
1answer
29 views

How to mark some columns as ignored for calculations Numbers?

I'm creating a template on Numbers and I would like to know if there is a way for the formula to ignore, or skip over some cells or even entire columns. I need these columns for some calculations, but ...
0
votes
0answers
24 views

Consolidating multiple sheets into one Numbers 3.6.1 OS X

I'm looking for a solution to automatically merge/consolidate the data from multiple sheets into one. I would like to stack the sheets on top of each other in it's own sheet. I would like to be able ...
0
votes
2answers
322 views

Style text in Numbers formula

I have a numbers formula used in invoice generation: ="Invoice terms: "&CONCATENATE(Terms)&", please pay by ..." Which returns: Invoice terms: 14 days, please pay by ... Is there a ...
1
vote
2answers
30 views

Conditional highlighting of booleans in Apple Numbers

Is it possible to do conditional highlighting of booleans in Apple Numbers? I want to highlight TRUE values one way, and FALSE values another, but booleans don't seem to be supported - only numbers, ...
0
votes
2answers
7k views

I've just updated my Mac to Yosemite and now I can't open a .numbers file

I have just updated my Mac to Yosemite and after that when I try to open .numbers file, I couldn't, and it gives me this message "edit 1.numbers can't be opened". I do not know why and I really need ...
3
votes
1answer
2k 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
13 views

How to type floating point numbers in Apple Numbers in Persian?

When I want to insert a floating number in Apple Numbers 3.6.1 in OS X 10.10.5 while my primary preferred language in Language & Region is Persian(فارسی), the number is interpreted as a string ...
0
votes
0answers
21 views

Exporting from Numbers to CSV file

I am trying to export a spreadsheet out of Numbers into a CSV file. I know where and how to do this, however the file that is created is still generating a formatted table rather than having the ...
0
votes
1answer
33 views

Is there a formula or function for Numbers that returns the number of days or weeks for a given year

I have a budget table with cost per week, fortnight, month, quarter and year. Some expenses are charged quarterly and others monthly or weekly, but I want to know what the value of a cell is for the ...
2
votes
2answers
4k views

How to export Contacts version 9.0 data or .abbu file to .csv or other usable spreadsheet format

In the newest Apple Contacts version 9.0, how do you export all contacts or an .abbu file to a .csv file or other usable spreadsheet format? Dragging and dropping to Numbers does not work. Exporting ...
0
votes
0answers
21 views

How to copy one cell's value to other cells of the same date in Numbers?

Given one spreadsheet in Numbers as the following. Column A is datetime, and column B is the value. For each date (ex, 2015-12-01), there is just one cell with non-empty value on 05AM. Ex, there are ...
0
votes
1answer
17 views

How do you remove a hyperlink from a cell in Numbers '08 version 1.0.3?

I have an address in a cell which is hyperlinked. I've also searched other posts on the topic and the selecting text and "right-clicking" does not bring up a menu with how to remove the link. I'd ...
2
votes
2answers
4k views

Auto-Populate A Pop-Up Menu in Numbers 3.5

I'm trying to steer clear of Excel, despite my sister's nagging, and I've done pretty well to create a Quote and Invoice workbook in Numbers. The problem I am having is working out how to ...
-1
votes
1answer
76 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 ...
0
votes
1answer
58 views

Number 3.6.1: Cell value needs to be invisible, if the adjacent checkbox is checked

I'm not sure if this is the right forum, but here goes: I would like to keep the cell value (E8), if the adjacent cell (D8) is false (checkbox is not checked), else insert zero or null. I just keep ...
4
votes
2answers
89 views

How to get the month name in English using Numbers?

I'm using Apple Numbers v 3.6.1 on OS X 10.11 to automatically fill all the info I need to generate a receipt each month. "... " & MONTHNAME(MONTH(TODAY())) & " 1 − " & ...
0
votes
1answer
30 views

Repeating a formula for every row in Pages

I'm working on a simple formula in Pages where I have a table with 4 cells per row. Product Name, Purchase Price, Quantity and Total. I've created a simple formula that multiples Purchase Price ...
1
vote
1answer
20 views

Display point values on numbers graph

On an Excel graph, if I mouse-over a data point on the graph, the application shows me in a small pop-up window the exact X and Y data values of the point that I am mousing-over. Is there a way to do ...
2
votes
6answers
8k views

Is it possible to remove cell borders from Numbers?

I imported an Excel spreadsheet that contained a few cells with black lines as their border. Is it possible to remove these outlines through Numbers (iOS)? I have tried copying and pasting, the ...
0
votes
0answers
53 views

“Database” report writer for Numbers?

I serve on the Board of a Baroque Orchestra and have begun helping them get organized. The management of the orchestra does not have extensive technical skills so I've endeavored to help provide them ...
5
votes
1answer
114 views

How to calculate max with condition in Numbers?

How can I calculate max with condition in Numbers? In other words, I want something like maxifs, which operates max operation instead of sum operation for sumifs.
1
vote
2answers
46 views

Nested IF statement in Numbers

I am working on a table to tabulate mileage costs for my small business. I have 3 destinations I go to on a regular basis. I would like the address to automatically populate in the C cell if the ...
0
votes
1answer
16 views

Display blank on formula error

I'm making a timesheet. I have =sum (A2-A1) but I have more than one task a day and not all times are used. The cells without time in them result in an error with the formula. Which, in turn, choses ...
1
vote
1answer
18 views

Numbers Between Formula

IF(AND(B13≤74,B13≥75,B13>90),"0","3, 5") Hey guys im basically trying to generate a if statement that outputs either 0 if under 74 or under 3 between 75 - 89 and 5 for over 90. I have been trying ...
0
votes
1answer
51 views

How to change y axis numbers in Numbers for mac to show as custom letters or words?

I'm new to Numbers and now creating my first chart. I tried to find what I was looking for on google but couldn't find anything. What I would like to do is change the numbers in the Y axis to show has ...
0
votes
0answers
44 views

Numbers for Mac : Sumifs formula

I have problem with my sumifs formula. I am trying to get enter image description here. I want to achiev this: Sum C5:C7 from all lists that contain word Teletnik and in the first list Formular you ...
2
votes
1answer
1k views

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

I have the following formula SUMIFS(Daily Log::Income,Daily Log::A,"≥"&A3,Daily Log::A,"<"&A4) that I want to sum income over the associated month. As you can see, it's not doing what ...
0
votes
0answers
21 views

How can I change the behavior of alt-return and return in Numbers 3.6?

According to https://discussions.apple.com/thread/2448952?start=0&tstart=0, there's a box at the bottom of the table inspector: There are at least two ways to make multiple lines in a cell. ...
0
votes
1answer
32 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 ...
2
votes
1answer
34 views

Round displayed value in Numbers for iOS to 2 decimals

Say I have the value 2.3638383 in a cell in Numbers for iOS (iPhone). Can I format the numbers so only 2 decimal places are shown (rounded to nearest decimal)? So 2.3638383 would be displayed as 2.36? ...
0
votes
2answers
46 views

Reinstalling Numbers on Mac OS X

Numbers was installed with a different Apple ID to mine (my bosses), so it won't let me update it (when it prompts for credentials, you can't overwrite the user name). I therefore need to reinstall it ...
2
votes
3answers
2k views

Connecting MySQL DB to Apple iWork Numbers?

I'd like to visualize some data from a MySQL database using a Mac, but it hasn't been easy finding a solution to this. I understand Excel has DB connectivity, but currently I only have Apple Numbers. ...
1
vote
0answers
120 views

The font Calibri is missing. Your text might look different with Pages, Numbers

My documents do not contain that font anywhere. But the iPad still complains about this. How can I remove completely these font from document? Is there a way to do this? Maybe there are special ...
1
vote
1answer
3k views

How can I add custom error bars to a graph in Numbers

I am using numbers 2014 - above is a screenshot that should explain it.
0
votes
0answers
27 views

Highlighting Cells in Numbers (but the highlights not show up when printing)

I have Numbers Version 3.6.1 on a MacBook Pro. I'm wondering if it's possible to have a cell highlighted/coloured in (denoting it is supposed to be edited) but have it not print highlighted? I see ...
0
votes
0answers
13 views

Generate the averaged color for the cell based on a range of other colored cells

I have a range of cells, each one is colored in yellow, green or red. I want to have a "total" cell, that shows me "averaged" color. Here is how my table looks like: Is that possible to do with ...
0
votes
2answers
999 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 ...
0
votes
1answer
37 views

Why doesn't Numbers remember my last cell position?

For latest release of Numbers for iPad, it seems that it doesn't remember the active cell when I close the spreadsheet. I have spreadsheets with many (several hundred) rows and in previous releases, ...
0
votes
1answer
12 views

Is it possible to add an HTML Snippet to Numbers on OS X?

Is it possible to add an HTML Snippet to Numbers on OS X? I would like to add some html code and have Numbers treat it as such, for example to use iframes embed websites into my document. Would this ...