New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Numbers - sort columns by month


Post Reply New Thread Subscribe

 
Thread Tools
neilf

 
Member Since: Apr 12, 2008
Posts: 377
neilf is an unknown at this point

neilf is offline
Hi all,
Anyone have any experience sorting iWork Numbers columns by month. I have a column set up using the pop-up menu to define all the months. So if I change a month for a particular cell, how do I re-sort it by month order?
All it seems to do, is sort the months alphabetically.

Is it worth getting "The Missing Manual?"

Thanks

Neil
QUOTE Thanks
shades

 
Member Since: May 20, 2004
Posts: 243
shades is a jewel in the roughshades is a jewel in the rough
Mac Specs: iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB

shades is offline
Howdy. That is true in most spreadsheets (unless something specific is added). I have always found it easier to use the number for the month, then it will always sort correctly.

Mellel 3, NWP 2, Scrivener 2.3.1, Tinderbox 5.11.2
LibreOffice 3.6, Accordance 10.0, Adobe CS4, DTP 2.4.3
OS X 10.8.2
QUOTE Thanks
neilf

 
Member Since: Apr 12, 2008
Posts: 377
neilf is an unknown at this point

neilf is offline
Reason I asked, is that I was sure I was able to do it recently, but forgot how.
QUOTE Thanks
Sawday

 
Sawday's Avatar
 
Member Since: Nov 19, 2006
Location: York, UK
Posts: 999
Sawday is a jewel in the roughSawday is a jewel in the roughSawday is a jewel in the rough
Mac Specs: 24" Aluminium, 2.8 GHz, 4Gb RAM. iPad2, iPhone4

Sawday is offline
Create another column to hold month number and sort on that? You could set the number using a VLOOKUP table (that is in Excel terminology - not sure what Numbers formula is).

Happiness is not getting what you want, but wanting what you get.
QUOTE Thanks

Post Reply New Thread Subscribe


« How do you repeat a command in iMovie? | video accelerater »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Copying data from email into numbers on iMac Andy and Shell Apple Desktops 0 03-08-2009 05:22 PM
Cutting and Pasting from emails into Numbers Andy and Shell Switcher Hangout 0 03-08-2009 05:20 PM
Song of the Month? DCraver Community Suggestions and Feedback 13 10-02-2005 08:25 AM

All times are GMT -4. The time now is 04:24 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?