Java Games: Flashcards, matching, concentration, and word search.

ExcelAdv_Lesson 7_Custom Number Formats_Activity 3

AB
mdisplays the month as a number without leading zeros (1 - 12).
mmDisplays the month as a number with leading zeros (01 - 12)
mmmDisplays the month as an abbreviation (Jan - Dec).
mmmmDisplays the month as a full name (January - December).
mmmmmDisplays the first letter of the month (J - D).
dDisplays the day as a number without leading zeros (1 - 31).
dddisplays the day as a number with leading zeros (01 - 31).
dddDisplays the day as an abbreviation (Sun - Sat).
ddddDisplays the day as a full name.
yyDisplays the year as a two-digit number.
hdisplays the hour as a number without leading zeros 0 - 23).
mDisplays the minute as a number without leading zeros (0 - 59).
sdisplays the second as a number without leading zeros (0 - 59).
[]displays hours greater than 24 or minutes or seconds greater than 60.
AM/PMDisplays the hour using a 12-hour clock.
ssDisplays the second as a number with leading zeros (00 - 59).
mmDisplays the minute as a number with leading zeros (00 - 59).
hhDisplays the hour as a number with leading zeros (00 - 23).
yyyyDisplays the year as a four-digit number.


Instructor
triOS College
Kitchener, ON

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities