Date, time and number patterns i Google spreedsheet

Formatting dates, time and numbers in a Google spreadsheet is very simple using the Text() method - like this

=TEXT( NOW() ; "yyyy" )

but it's only simpel if you know the different format patterns ;) They are not very well documented but there is a spreadsheet out there with all the answers. Go here

http://goo.gl/lUUo4

I'm sorry but I know who to give credit for creating all this information - but he/she should have a medal.