1 Format options
Create a new spreadsheet. Select a single cell, an entire row or column of cells. Click the Format icon at the top-right of the app then click Cell to display the formatting options.
2 Create Custom Format
Click on the drop-down tab under Data Format. Click Create Custom Format. Give it a name and select the Number format type. This will determine what tokens and rules can be added.
3 Add tokens
Drag the currency icon into the Custom format bar, followed by an integer token and a decimal token. Add any other tokens you want to use. From the drop-down you can modify a token.
4 Test your formatting
Click OK. Now type a number into your selected cell. The custom tokens will automatically be applied to it. Compare this to inputting the same number into a non-formatted cell.
5 Date & Time
Create a new custom format. Select Date & Time as a type. Date & Time tokens let you work from the millisecond right up to the era. You can also add text to any custom cell format.
6 Using formatted cells
Click OK. Add a date and time to the formatted cell in any format, such as 16/4/14 09:08, then hit Enter. The cell will automatically be formatted to include all of the added tokens.
Click Image to Enlarge: