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 code into a Numbers spreadsheet **005566778899**, Numbers will automatically convert that to **5566778899**. This is not what I would want... However, the way *I* use Numbers, I open databases with thousands of UPC codes with preceding zeroes. Some of them also contain **dates** which Numbers will also reformat. Basically I do not want any of these features, I want my content to be left alone. # How can I get Numbers to leave my data intact when I open a CSV file? *Converting the fields to text after importing won't help since the data was already messed with...*

I am not sure how to set up this conditional. Say I have a table like so: | Animal | Totals | |:---- |:------:| | Cat | 10 | | Dog | 6 | | Cow |4 | and a second table like so: | Type | Type Total | Animal | Animal Total | |:---- |:------:| -----:|-----:| | Black | 5 | Cat | XX | | Retriever | 3 | Dog | XX | | Brown | 2 | Cow | XX | | Calico | 5 | Cat | XX | | Hound | 3 | Dog | XX | | Oreo | 2 | Cow | XX | What I am trying to write a formula for is: If a cell value in Table 2, Col C (Animal) matches a cell value in Table 1, Col A (also Animal) populate the corresponding cell in Table 2, Col D (Animal Total) with the value from Table 1, Col B (Totals). I'm not sure how to structure that formula.

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, offset, for no obvious reason. Presumably I hit the wrong shortcut key and didn't notice at the time. I assume the given answer will solve my problem... but I don't understand what it's telling me to do, and I don't seem to be able to add a comment to the thread. What it suggests doing is as follows: > Select both, then open the format inspector, choose Table and check the Table Names checkbox. > > Both tables should have the same name. The duplicate will have " - 1" added to the end. > > Afte checking that any recent editing has been done in the origina (and repeating it there if that is not the case)l, delete the duplicate. This isn't at all clear to me. How do I "select both"? I have the format inspector opened... I think... but there is no Table Names checkbox. (Maybe this is due to my failure to "select both"?) How do I "delete the duplicate"? (OS 10.14.6, Numbers 10.1 (6913))

I'd like to open an old Numbers file that contains calls to the current stock price function and see all the values that it held as of the date it was saved. Can I disable the function somehow before opening the file? I've tried disconnecting from the network before opening the file, but somehow the values seem to be magically updated anyway. Should inserting the date the file was saved in all the calls to the stock price function restore the data correctly?

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 text into columns (text separated by commas or spaces, for example). In Numbers, such an option doesn't exist that I know of. Second, how can I import text (including numbers) as text? With windows I can do both of these functions with the Text Import Wizard and with Numbers I can't do either. The only solution I've found to the first problem is to download a custom workflow that I found in this Apple Community thread: https://discussions.apple.com/thread/8293955 And a less elegant solution is also discussed here but it's much more clunky: https://apple.stackexchange.com/questions/111512/how-can-i-do-text-to-columns-in-numbers?rq=1 Regardless, I still haven't found a way to import numbers as text.

From Apple Number’s [doc](https://support.apple.com/en-gb/guide/functions/ffa3e86ad3f3/10.0/web/1.0) , the formula CURRENCYH should return historical currency data. > Examples > > =CURRENCYH(“USD”, “GBP”, 3, “18/04/2017”) returns £0.78, the lowest rate of exchange (“low” or 3) from the United States dollar (USD) to > Pounds sterling (GBP) on 18 April 2017. > > =CURRENCYH(“gbp”, “bmd”, “open”, “31/12/2015”) returns BMD1.48, the exchange rate from Pounds sterling (GBP) to the Bermudian dollar (BMD) > at the beginning of trading on 31 December 2015. > > =CURRENCYH(“usd”, “aud”, “close”, TODAY()-2) returns the exchange rate from United States dollars to Australian dollars (in AUD) at the close > of trading two days ago. However, when I try it with TODAY()-2 (writing as of 4 May 2020) and a couple of previous days, it shows the error **The requested historical date is invalid or is in the future.**

I have to go back to 4 Apr 2020, and the error message became **There is no historical data on the requested date. The next available is on 6/4/2020.**

After updating to 6 Apr 2020, I managed to get the USDGBP rate and it is all available up until 17 Apr 2020, then became unavailable.

To summarise with a quick test from 1 Apr: - 1-3 Apr are available - 4-5 Apr are **NOT** available - 6-17 Apr are available - 18 Apr - 4 May are **NOT** available It seems very unreliable for getting the currency rate for a specific date in Numbers. Is this expected, and how can I fix it?

I have a following set of data [time] [value] ...97 lines... In another table I set intervals like [from] and [to] like 9:00 to 9:09 I'm trying to count occurrences of data in each interval by =countifs( , concatenate(", concatenate(">", [to]) ) I played with adding " to concatenate formula, timevalue. Still get 0 as a result. E.g. can't create correct condition for countifs function. Please assist!

I am trying to make conditional highlighting accross whole row when a checkbox is checked. I found a tutorial to make this happen, but it doesn't work for me. If you know a better way to do this, please show me how. At this moment I am trying to use formula from the tutorial: Where A3 is the checkbox. When I check/uncheck the checkbox I see in the bottom statusbar TRUE/FALSE state, but the formula is not working. In the example it's always showing "NOT YO".

I'm trying to use a 2d bar chart, and the Scale Max / Min is locked with 'auto' in similar to how this graph question. QUESTION & ANSWER

I have two tables (sheets) in a single workbook: * Table 1: Name, Amount * Table 2: Name, Yes-No I want to (sum all of the Amounts) in Table 1 where (Table 1 and Table 2's name are the same) and (Table 2's corresponding Yes-No is Yes). In a relational database, this is trivial, but how do I do it with Apple Numbers?

I have a 20,000 line spreadsheet in Apple Numbers, and I need to fill a column with data. I don't want to sit there dragging down the fill handle for thousands of rows. How can I fill the whole column with a value?

I need help with the following Apple Numbers REGEX.EXTRACT formula that doesn’t return the word before a dot. Below are the text form of the arguments passed to the formula and the formula itself as well as a screenshot.

Pattern: \b\w+\b(?=\.)
String: 123. xpto.
Formula: REGEX.EXTRACT(“123. xpto.”, \b\w+\b(?=\.),1)

I need to count the words in each cell of a table. There’s no built-in wordcount function, so I’ve previously used a couple of methods that effectively count the number of spaces, adding 1 to get the correct total. But this is inadequate since my text often includes dashes as punctuation which get counted as extra words. A complication is that if two words are joined by a hyphen without whitespace, they should be counted as a single word, so I don’t just want to treat all hyphens as whitespace in a solution. What formula can accurately count the number of words in a cell?

I did an experiment to find out it isn't a numbers problem rather the keybinding cmd + x currently does this behaviour. I tried cutting a link from the address bar and pasting into another address bar of another tab, I started facing the same issues. It isn't just a Numbers app problem, but that’s where I first noticed it. How can I determine if this is the macOS reacting to this command?

I noticed some time ago, that a thousands separator space became smaller in width. No matter if I change locale in system settings, the size of a space stays the same. Can't find any setting to change this. Can barely see any difference.

Is this possible, like you can in other spreadsheet software to do something like this? (color scales)

In Numbers.app on iOS, is it possible to trigger a response if sheet contains differing data to other sheets in same file? If not able to formulate on iOS, then on a Mac? And will the trigger still show up when viewing same file on iOS? - Sheet 1 = contact list from phone A - Sheet 2 = contact list from phone B - Sheet 3 = message list from phone C - Sheet 4 = contact list from phone

contact name for phone 123-456-7890

- Sheet 1 = *contact doesn’t exist* - Sheet 2 = Jane Doe - Sheet 3 = Jane Doe - Sheet 4 = Ashley How can I set a trigger that will alert me to Sheet 4’s cell “Ashley”? Each sheet contains different - number of rows - column headers

How can I have Numbers autofill interpolated values in a range of selected cells (from the value of the first cell to the value of the last cell)? I know how to do this with a formula but it's too awkward as I do this quite frequently. Therefore, I would like to use the Autofill function, or similar. But it doesn't seem to be intelligent enough to interpolate. Ex: […] […] […] ➾ [7.75] [8.5] [9.25]

I have this table that was created by using the "Form sheet" on iPad

Table A
-------------------------------------
Month   | Rent | Groceries | Netflix |
January |  100 |       100 |     100 |
February|  200 |       200 |     200 |
-------------------------------------

Naturally, it's weird that the months are the columns, and not the rows. So I want to create a 2nd table that references this table, but transposed

Table B
---------------------------------
Description | January | February |
Rent        |     100 |      200 |
Groceries   |     100 |      200 |

I can make the Cell reference the other table, but when I click+drag to autocomplete the remaining cells (around 20), they follow the column. Table B January Groceries points to Table A February Rent. Of course I could do it manually but it'll take me a few hours, and I'll have to manually update each table if I insert a new column on Table A

I have little to no knowledge when it comes to Numbers/other data programmes. I’m working with a client and I want to create a line graph to show how these variables affect each other (eg. Does food consumption/exercise affect sleep) but i’m having no luck. Is it even possible or would I need to only select two variables (including/excluding the date?) As you can see, despite selecting the table I want to use, the line graph produced seems to be completely unrelated? I’ve also tried creating a line graph with just two variables (see below) but the graph still doesn’t seem to make sense. I don’t want anything fancy, just an easy way to view how different variables affect each other 😅 Any help would be greatly appreciated!