most recent 30 from http://appleinquiry.com 2010-02-08T23:08:50Z http://appleinquiry.com/feeds/tag/numbers http://www.creativecommons.org/licenses/by-nc/2.5/rdf http://appleinquiry.com/questions/20/moving-a-value-in-alist-to-another-list-with-a-reference-number Stef Ringoot 2009-10-14T18:15:27Z 2010-02-08T19:25:32Z

<p>Hi folks,</p> <p>Sorry for the bad English, but normally I speak dutch, so... I have a question;</p> <p>Is it possible, in numbers, to create a list, for example</p> <p>1001 computer <br> 1002 software <br> 1003 supply <br> 1004 Machines <br> 1005 goodwill <br> 1006 credit <br> 1007 sell <br> etc, etc, ....<br> and then use these numbers in another table (on another page) where it grabs a value an puts that value in a third table (again on another page)</p> <p>for example I have a table with some info an a amount</p> <p>jan 10 | bought a mac computer | 2500 Euro | ...<br> jan 17 | Bought software | 1550 euro | ...<br> jan 22 | sold some drawings | 750 euro | ...<br> jan 25 | bought a cd player | 100 Euro | ...<br> jan 25 | print ink | 25 Euro | ...<br> feb 01 | print ink | 25 Euro | ...<br> feb 13 | Bought software | 250 euro | ...<br> feb 22 | print ink | 25 Euro | ...<br> etc, etc</p> <p>where the .... are I now want to put the code so it will look like</p> <p>jan 10 | bought a mac computer | 2500 Euro | 1001<br> jan 17 | Bought software | 1550 euro | 1002<br> jan 22 | sold some drawings | 750 euro | 1007<br> jan 25 | bought a cd player | 100 Euro | 1001<br> jan 25 | print ink | 25 Euro | 1003<br> feb 01 | print ink | 25 Euro | 1003<br> feb 13 | Bought software | 250 euro | 1002<br> feb 22 | print ink | 25 Euro | 1003<br></p> <p>so this should result in another table which should look like</p> <p>1001 - 1002 - 1003 - 1004 - 1005 - 1006 - 1007 <br> -----------------------------------------------<br> 2500 - 1550 - 0025 - 0000 - 0000 - 0000 - 0750 <br> 0100 - 0250 - 0025 - 0000 - 0000 - 0000 - 0000 <br> 0000 - 0000 - 0025 - 0000 - 0000 - 0000 - 0000 <br></p> <p>-----------------------------------------------<br> 2600 - 2800 - 0075 - 0000 - 0000 - 0000 - 0750 <br></p> <p>is this possible in numbers?</p> <p>greetings from Holland</p> <p><a href="http://www.stefringoot.com" rel="nofollow">www.stefringoot.com</a></p>

http://appleinquiry.com/questions/25/what-is-the-best-site-to-find-templates-for-numbers Michael Baggett 2009-10-17T15:23:10Z 2010-02-08T09:27:33Z

<p>A little self-serving, but I'm curious if I am missing other sites on the interwebs.</p> <p>Given that Apple ships a limited number of templates with Numbers, what are you favorite sites for finding new templates?</p>

http://appleinquiry.com/questions/32/numbers-gradebook Kelly 2009-10-18T20:39:51Z 2010-02-06T21:27:27Z

<p>Sometimes I like to drop the lowest grade for my students...or I may not make up a test when a student has been absent. When I leave a space blank on the grade book, it is calculated as a zero percent and brings the final grade down to failing. How can I prevent this from happening?</p>

http://appleinquiry.com/questions/71/using-hoursminutes-in-numbers Caryn 2009-12-07T15:25:44Z 2010-02-06T21:27:27Z

<p>I need to create a timesheet that will display my time worked in 00:00 format. I had this all worked out in Excel, and moved it to Numbers, which shows errors.</p> <p>Biggest problem is the cell where the time is added together, for a total time for the week. I get an error, saying that "The formula's arguments can only include one date value"</p> <p>I have used the duration function, entering 24 hours. I am entering my time as 00:00.</p> <p>I have looked for a template on the web that has a similar layout, but they all display the time as 0h0m.</p> <p>Please help!</p> <p>Thank you</p>

http://appleinquiry.com/questions/92/how-do-you-add-a-category-in-numbers-checking-registry-template Jennifer Lonergan 2010-01-10T00:30:56Z 2010-02-03T21:27:32Z

<p>I would like to add other categories that would be included in the pie chart - any help is welcome - thanks!</p>

http://appleinquiry.com/questions/57/automatic-tables-in-numbers Alice 2009-11-08T12:22:11Z 2010-02-02T23:28:21Z

<p>Hi, I was wondering if it's possible to script in Numbers. Let me take an example.</p> <p>When i type 20 in one cell, another table should populate itselft with 20 rows. Is this posible?</p> <p>Best regards, Alice</p>

http://appleinquiry.com/questions/95/changing-default-text-size-in-numbers Jean 2010-01-15T20:02:59Z 2010-02-01T18:24:29Z

<p>How can i change the default text size for cells in Numbers?</p>

http://appleinquiry.com/questions/64/creating-borders-in-numbers09 Harsh 2009-11-15T18:50:28Z 2010-01-31T21:23:51Z

<p>I am ready to pull my hair apart in frustration. Everytime I create borders to my selection in the table, specify style, line width, colours etc. and then when I click elsewhere on the sheet, the border invariably disappears. I am not able to make the border permanent. What am I missing here? Need help please. </p>

http://appleinquiry.com/questions/45/can-i-export-a-numbers-document-as-form-fillable-internet Courtney Rice 2009-10-23T03:27:39Z 2010-01-29T22:23:57Z

<p>Is it possible to export a numbers document as an internet style form fillable document with full functionality? Thanks for any help.</p>

http://appleinquiry.com/questions/41/iwork-numbers-borders Jim 2009-10-21T15:05:30Z 2010-01-29T00:41:50Z

<p>I cannot make the borders in a Numbers table stay in the table nor print?</p> <p>Frustrated,</p> <p>Jim.....</p> <p>Thanks Michael for the vidio.</p> <p>I neglected to tell you that I did select the entire table, then apply the "Inside Borders" selection and the borders appeared. I also selected "Apply Border Selection" from the "Borders" menu. Then if I click anywhere within the table or outside of the table the borders disappear. Also after applying the borders and then going to print the borders do not print. I even went so far to reload the Numbers application from disc.</p> <p>Thanks again for the updated video. I noticed the step that I was not doing - after selecting the border type, select the line type. That did the trick.</p> <p>Thanks again,</p> <p>Jim......</p> <p>Jim.....</p>

http://appleinquiry.com/questions/44/transposing-row-and-columns-in-inumbers Rex 2009-10-23T03:14:41Z 2010-01-26T11:24:03Z

<p>I currently use Excel and I am in the process of switching to Numbers. In excel it is easy to transpose rows and columns. How is this done in Numbers?</p>

http://appleinquiry.com/questions/102/using-numbers-to-put-credit-card-charges-into-accounting-categories Rand Larson 2010-01-26T00:34:34Z 2010-01-26T00:34:34Z

<p>I am currently going thru my credit card statement and adding up all of the charges by categories so I can enter the charges into MYOB Accountedge - this is to keep my accounting correct and I pay the credit card from AccountEdge. I'm thinking that a pencil and calculator is so 1980. Maybe Numbers can be used?</p> <p>I made a very simple template and listed the expense categories going down the left and have each row showing a total on the far right. Then all of the totals are added up to a grand total on the bottom. If I do it right, I enter each charge manually in the correct category and Numbers does the math for me.</p> <p>But I have a hunch that I'm not doing it the best way. This is my first time really using Numbers or any spreadsheet. I'm afraid that printing this out can be a real pain. For example if I enter each auto fuel charge for the month the spreadsheet will have to get very wide. Printing will be a challenge.</p> <p>Does anyone have suggestions? Has anyone made a template to consolidate their credit card charges by category? This has to be a common task that someone has figured out. I hate reading manuals...</p> <p>Thanks.</p>

http://appleinquiry.com/questions/100/how-do-i-change-a-field-in-numbers Dena 2010-01-21T15:16:51Z 2010-01-21T15:16:51Z

<p>I'm trying to use the "event planner" template, but it will not let me change the fields! I can delete, but not add new. If i hightlight and type, I click on the next field, and the old info comes back. It has to be that easy, right? So is there just something wrong with my mac? I'm ready to toss it! HELP!!!</p>

http://appleinquiry.com/questions/94/still-having-trouble-with-cell-borders Jean 2010-01-15T19:49:35Z 2010-01-15T19:49:35Z

<p>Everytime I try to make cell borders they disappear when I leave the inspector and come back to the page. i tried the solution in the answer to the same question of clicking on the color and it seemed to work - once! </p>

http://appleinquiry.com/questions/86/solver-for-numbers Rdlc 2009-12-31T01:38:19Z 2009-12-31T01:38:19Z

<p>Where can I find a Sover Type programme for Numbers (Newton Rapson, Linear Programming optimization)?</p>

http://appleinquiry.com/questions/84/numbers-highlighting-weekends-on-a-chart Simon Cragg 2009-12-30T10:23:14Z 2009-12-30T10:29:17Z

<p>I have a table in Numbers with 2 columns: Date and Sales.</p> <p>I've created a line chart from this table, with the dates along the bottom and the sales down the side.</p> <p>How can I highlight which sales sit on a weekend. Ideally I'd like the background to be colored differently for weekend date columns, however I would settle for a different colored data point.</p> <p>Hope this makes sense. </p>

http://appleinquiry.com/questions/83/how-can-i-change-cell-formatting-in-iwork-numebrs-09-if-length-of-its-string-valu garcon 2009-12-29T15:56:07Z 2009-12-29T15:56:07Z

<p>I cant find that choice in Conditional Format Rules dialogue.</p>

http://appleinquiry.com/questions/66/npv-using-excel-versus-numbers dshields 2009-11-18T17:24:46Z 2009-11-18T17:24:46Z

<p>Why does the result when solving for NPV (using function key) differ between Excel and Numbers? Can this be "fixed" / changed? </p>

http://appleinquiry.com/questions/65/numbers-can-i-add-a-photo-to-a-cell-as-data Galen Greenlaw 2009-11-16T14:37:13Z 2009-11-16T14:37:13Z

<p>I am looking to search and create a "LookUp" Function with Images/Photos... Can I place an Image/Photo into a cell as data????</p>

http://appleinquiry.com/questions/12/how-do-i-make-numbers-the-default-app-for-opening-excel-files Michael Baggett 2009-10-14T00:20:34Z 2009-10-16T15:54:53Z

<p>I have both Numbers and Excel installed on my Mac. How do I make Numbers the default application for opening Excel documents?</p>

http://appleinquiry.com/questions/10/how-do-you-join-concatenate-text-in-numbers Michael Baggett 2009-10-13T23:59:14Z 2009-10-14T00:01:04Z

<p>Let's say you have some text in one cell, and some other text in a different cell. You want to join the text together into a third cell.</p> <p>How do you do this in Apple's Numbers spreadsheet?</p>