1 Format optionsCreate 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 FormatClick 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 tokensDrag 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 formattingClick 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 & TimeCreate 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 cellsClick 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: