Tip: Formula to Format Telephone Numbers

Wednesday, November 7th, 2007

I just found this great formatting tip over on the Apple Numbers discussion boards. A poster had the following problem: He had a series of phone numbers formatted as 10 digits (i.e. 5035551212). He wanted to re-format the numbers to read as (503) 555-1212. 5|=vv (who is also a frequent ...

Numbers For The Rest Of Us Book

Saturday, November 3rd, 2007

Forum member, JaxJason, is working on a short format book/tutorial on Numbers. To quote from Jason’s first post on the project: Ok, here is my first attempt at a little book to help people pick up Numbers. It is written in a conversational tone. It is purposefully not written ...

Template: Problem Solving Using the Toyota A3 Method

Wednesday, October 24th, 2007

Forum member Steve has shared a cool Numbers spreadsheet template on the forums, that allows a user to use the A3 problem solving methodology to work through business process problems. Steve describes the template: This is another tool that I have found very useful in small (30 people) and large (40,000 people) ...

Mac OS X 10.5 - Leopard

Saturday, October 20th, 2007

Mac OS X 10.5 (Leopard), will be released on October 26. Amazon is making Leopard available for pre-order with free shipping. You can also get $20 off the retail price of the single-user license, and $10 off the retail cost of the family pack (which allows you to upgrade up to five ...

Template: Scuba Dive Log for Apple iWork Numbers

Saturday, October 20th, 2007

Forum member, Bjoern, has shared another of his Numbers Templates. This is a scuba diving log. I am not a diver myself, but those of you who are, may find this interesting. Bjoern used this while on a trip to Egypt to dive in the Red Sea. It ...

Measurement Conversion Sheet for Apple iWork Numbers

Friday, October 12th, 2007

Forum maestro, JaxJason, posted this cool little converter spreadsheet back in September. At first blush, there isn’t a lot going on with this. The first sheet presents just one table, with two drop down boxes: one for choosing the unit measurement you would like to convert to, the ...

Template: Project Template With Gantt Chart for Apple iWork Numbers

Saturday, October 6th, 2007

Forum member Bjoern has been kind enough to share his Project Template with Gantt chart. The template includes: a project description area, a fuel-gauge style chart, and columns for WBS (Work Breakdown Statements), Tasks, Task Leads, Start Time, End Time, Duration (in days), and a neat in-cell chart. You can view the ...

Conditional Formatting Hack

Friday, October 5th, 2007

I would like to share a very interesting tip that forum member 5|=vv posted on the Apple boards. The question posed was: I was wondering if two columns have the same value can I establish a condition that would underline one column? Example: Orig. Price Current Price $200,000 ...