Format("01/06/98", "General Date")' 1/6/98
Format("01/06/98", "Long Date")' Tuesday, January 06, 1998
Format("01/06/98", "Medium Date")' 06-Jan-98
Format("01/06/98", "Short Date")' 1/6/98
Format("01/06/98", "mm-dd-yyyy")' 01-06-1998
Format("01/06/98", "dd")' 06
Format("01/06/98", "ddd")' Tue
Format("01/06/98", "dddd")' Tuesday
Format("01/06/98", "m")' 1
Format("01/06/98", "mm")' 01
Format("01/06/98", "mmm")' Jan
Format("01/06/98", "mmmm")' January
Format("17:08:06", "Long Time")' 5:08:06 P.M.
Format("17:08:06", "Short Time")' 17:08
Format("17:08:06", "h")' 17
Format("17:08:06", "n")' 8
Format("17:08:06", "nn")' 08
Format(52486.2356, "General Number")' 562486.2356
Format(52486.2356, "Currency")' $562,486.24
Format(0.2, "Fixed")' 0.20
Format(562486.2356, "Standard")' 562,486.24
Format(562486.2356, "#,###.##")' 562,486.24
Format(.7521, "Percent")' 75.21%
Format(562486.2356, "Scientific")' 5.62E+05
Format(0, "Yes/No")' No
Format(23, "Yes/No")' Yes (because it's non-zero)
Format(0, "True/False")' False
Format(23, "True/False")' True
Format(0, "On/Off")' Off
Format(23, "On/Off")' On