New answers tagged numbers
Unfortunately, Apple removed that option in the menu bar. However, you can still get the today's date by manually typing it (obviously) or by selecting the cell and typing "=Today", followed by the return key. You can also type "=Date", followed by the return key. You can then manually select the date there.
You should be able to use COUNTIFS instead of COUNTIF, using the same range for each test-array/condition pair. =COUNTIFS(test-array,">=16",test-array,"<=30") In the following example, the formula in A8 is =COUNTIFS(A1:A6,">=16",A1:A6,"<=30") A B C D E 1 10 2 15 3 20 4 25 5 30 6 35 7 8 3
If you don't mind a separate column/table for this, you can check if each cell is between 16 and 31 like this: Table 2, A1: IF(x::A1>15,IF(x::A1<31,TRUE,FALSE)) Table 2, A9: COUNTIF(A,"=TRUE")
You can also replace the delimiters with tabs: Copy the cells and paste them to a new TextEdit document. Replace ", " with tab. You can insert a tab by pressing option-tab. Copy and paste the text back to Numbers.
Just open a file ("File" > "Open…") that ends in ".csv" and Numbers.app did the right thing with the data.
It generally is located in your Application folder, though may also be in a folder entitled iWork within Applications. You can try using Spotlight to find Numbers, if necessary...
In Numbers 3 Select the cell (or group of cells), and from the format panel, choose Cell. Click the conditional Highlighting and click Add a Rule... Choose the date tab, then "after ..." from the popup. 0 as the value. This rule will appear in the popup as "date is after the date" once it is selected. In the last box choose "Red Fill" In Numbers '09 ...
Also I have had the same problem and had to convert the file for it to work. See my workaround here: http://goo.gl/CKgDaV Hope this works for you too. :)
The first thing to do when troubleshooting an iWork app that connects to iCloud is to test launching the app from a brand new user. This will isolate whether your user settings are causing problems or the problem is truly with the App itself or the OS install. Open System Preferences Select Users & Groups Make a new user - test or something obvious. ...
Top 50 recent answers are included