Format[$](expr[, form$], [firstday], [firstweek])
Return the formatted string representation of expr.
expr Return the formatted string representation of this numeric value.
form Format expr using to this string value. If this is omitted then return the expr as a string.
firstday Format using this day as the first day of the week. If this is omitted then the vbSunday is used. (Only supported for Win32.)
firstweek Format using this week as the first week of the year. If this is omitted then the vbFirstJan1 is used. (Only supported for Win32.)
firstday Value Description
vbUseSystemFirstDay 0 Use the systems first day of the week.
vbSunday 1 Sunday (default)
vbMonday 2 Monday
vbTuesday 3 Tuesday
vbWednesday 4 Wednesday
vbThursday 5 Thursday
vbFriday 6 Friday
vbSaturday 7 Saturday
firstweek Value Description
vbUseSystem 0 Use the systems first week of the year.
vbFirstJan1 1 The week that January 1 occurs in. This is the default value.
vbFirstFourDays The first week that has at least four days in the year.
vbFirstFullWeek The first week that entirely in the year.
See Also: Predefined Date Format, Predefined Number Format, User defined Date Format, User defined Number Format, User defined Text Format.