iWork '08, Numbers data/time formats

Apple recently released a new version of the iWork office suite, which now includes a spreadsheet application, Numbers. One thing that annoyed me about Numbers was the data and time formats. I like to use ISO 8601 (YYYY-MM-DD) because I can never remember which is the month and which is the day in the MM/DD/YY or DD/MM/YY format, which is different between the US and Europe. Numbers doesn't have the ISO 8601 format, and doesn't allow you to specify a custom format. Which is kind of annoying, but it is the first release.

Fortunately, someone figured out how to do it. Here is how to do custom date formats in Numbers. . I Haven't tried it out yet though.

Now if only I could figure our how to add functions.... I need WORKDAY() for my schedules....