Skip navigation
Sign in or Register to find out more about Yellowbox
Name:
Yellowbox
Title:
Mr
Status Level:
Level 4 Level 4 (3,870 points)
Member Since:
Dec 27, 2012
Location:
New South Wales, Australia
Biography:
Mac addict in 1980s and 1990s. Returned to the Mac fold in 2012. Relearning Mac skills.
Occupation:
Soil Scientist (Retired)

Yellowbox's Products

MacBook Pro (13-inch Mid 2012), OS X Mavericks (10.9.2), Pages 4.3, Numbers 2.3, Numbers 3.2
Airport Express Base Station
Magic Mouse

Recent Activity

Yellowbox replied to Cross tab analysis

"Hi fercesar,   When you say tabs, do you mean the sheet tabs across the top of a document? Sheet 1, Sheet 2 and so on.     Each Sheet (c"

in Numbers for Mac 3 replies
2 hours ago
Yellowbox replied to Hi, i need categorize data by column, collapse, expand and summarize

"Hi Tapioca,   See the reply here by SGIII   https://discussions.apple.com/message/25438600#25438600   Regards, Ian."

in Numbers for Mac 1 replies
3 hours ago
Yellowbox replied to Can't open xlsx

"Hi Nick,   Which version of Numbers does not open .XLSX?   ever since I upgraded to the latest Numbers on Mavericks   If you downloaded N"

in Numbers for Mac 4 replies
21 hours ago
Yellowbox replied to data and time

"S-l-u-t (End) is a rude word in English. Aunty Apple replaced it with **** .   Regards, Ian."

in Numbers for Mac 19 replies
22 hours ago
Yellowbox replied to data and time

"Hi jon-eric,   for example mine now says "tuesday", so now it knows it's tuesday   Not necessary! WEEKDAY gives 2, which is less than 6. T"

in Numbers for Mac 19 replies
22 hours ago
Yellowbox replied to Combine "Pop-Up Menu" and "Text" format in one cell? (iPad numbers)

"Hi Andrea,   all the spreadsheets from the various iPads are later put together to one big excel file. One way is to combine the Pop-Ups"

in Numbers for Mac 5 replies
1 day ago
Yellowbox replied to Autofill not working in Numbers 3.2(1861)

"Hi Nalin,   Sorry for calling you Halin .   Glad to help. Thanks for the green tick and feedback.   Regards, Ian."

in Numbers for Mac 3 replies
1 day ago
Yellowbox replied to data and time

"Hi jon-eric,   This may help with part of the problem.   This is simply to illustrate a way of testing for mon, tue, wed, thur, fri wit"

in Numbers for Mac 19 replies
1 day ago
Yellowbox replied to Hide Zero Value's?

"Hi Josh,   Two ways I can think of.   1. If the zero is the result of a formula, use "" (NULL) as a possible result.   2. Use Conditional"

in Numbers for Mac 4 replies
1 day ago
Yellowbox replied to Autofill not working in Numbers 3.2(1861)

"Hi Halin,   Start your sequences with values.     Now fill down     Regards, Ian."

in Numbers for Mac 3 replies
1 day ago
Yellowbox replied to Autorrellenar fechas

"Hi Walter,   Enter the date for the first Monday in A2. Enter the date for the following Thursday in A3.   Enter this this formula into A4"

in Numbers for Mac 3 replies
1 day ago
Yellowbox replied to Autorrellenar fechas

"Please ignore. Wrong answer."

in Numbers for Mac 3 replies
1 day ago
Yellowbox replied to Is there any way to flip the X-axis on a chart?

"Hi tango,   Here is my first attempt. A table with the most recent date at the top. I can't get dates to format as you can (Mar- 14). I can"

in Numbers for Mac 17 replies
1 day ago
Yellowbox replied to Is there any way to flip the X-axis on a chart?

"Hi tango,   instead of graphing from October 2013 to October 2012 I want the graph to plot from October 2012 to October 2013.   Please po"

in Numbers for Mac 17 replies
2 days ago
Yellowbox replied to Documents not opening

"Hi Robin,   1. Maybe the icon (alias) on your Dock is still pointing to Numbers 2.3 (Numbers '09) and is failing to open a Numbers 3 docume"

in Numbers for Mac 1 replies
2 days ago
Yellowbox replied to HT3348 How to convert Numbers file to MS Excel file

"Hi Dennis,   Numbers 3.2. Menu > File > Export To > Excel...     That will create an Excel copy on your machine. Send it to your Excel f"

in Numbers for Mac 2 replies
2 days ago
Yellowbox replied to Custom Format is back!

"Hi Martin,   A touch of Old Timer's disease in me. I wrote: "carry a Custom Format to Numbers 2.3."   Should be: "carry a Custom Format to"

in Numbers for Mac 6 replies
2 days ago
Yellowbox replied to How can I add header on printing with Numbers

"Hi Tanya,   Glad to hear that you found how to edit page headers and footers in Numbers 3.2. I agree that Help in Numbers 3 is woeful. No se"

in Numbers for Mac 9 replies
2 days ago
Yellowbox replied to Lookup list?

"Hi SG,   As I was composing my reply with VLOOKUP, I knew that I was breaking my New Year's Resolution to get my head around the INDEX MATC"

in Numbers for Mac 7 replies
2 days ago
Yellowbox replied to Simple directions to format PLEASE!

"Hi deariedo,   Thanks for the green tick. Glad to help.   My screen shot is from Numbers 3.2 under Mac OS X Mavericks 10.9.2. My eagle ey"

in Numbers for Mac 7 replies
2 days ago
Yellowbox replied to Formulas

"Hi Barry,   EDIT: @Ian: Wouldn't elephants be sold by the metre (or by the kilogram)?   Only if they make trunk calls.   Ian."

in Numbers for Mac 4 replies
3 days ago
Yellowbox replied to Custom Format is back!

"Hi Martin,   A Custom Format created in Numbers '09. Document saved, closed, then opened in Numbers 2.3     Here is how to delete a Cus"

in Numbers for Mac 6 replies
3 days ago
Yellowbox replied to Lookup list?

"Hi oldroller,   Are you asking for lookup to return more than one column (field)?   If so, that will require a separate lookup function fo"

in Numbers for Mac 7 replies
3 days ago
Yellowbox replied to Formulas

"Hi nickbrooke,   Yes, using IF around the two different formulas will work.   IF(a certain cell equals "Each", then use this forumula, el"

in Numbers for Mac 4 replies
3 days ago
Yellowbox replied to Simple directions to format PLEASE!

"Hi deariedo,   Formula in G3 (and Fill Down):   =G2+F3   I have hidden Columns B to E just to make a smaller screen shot.   Opening ba"

in Numbers for Mac 7 replies
3 days ago
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.