1. Open a file in Numbers
2. Click Inspector
3. Click on the little blue square (4th from the left)
4. Click the letter above the column you wish to change
5. Click the drop down menu under Cell Format
6. Select Date & Time
7. Select the drop down menu next to date & change accordingly
8. Repeat with Time
1. Click the drop down menu under "Cell Format"
2. Select Custom
3. Type in a name for the format
4. Select if it will be for numerical data or date & time (in this case we are working with date & time).
5. Select the data which you wish to have appear first
dsf6. Click, HOLD and drag the value to the bar (let go when you see a green plus sign appear)
7. To change the appearance of the value, hover your mouse over top of the value until you see a small arrow appear to the right of the value
8. Click on the arrow and select your desired appearance.
** remember to physically click on the bar to type in a symbol such as : or , and to add a space between values.