Format$ Function

Syntax              Format[$](expr[, form$], [firstday], _
          [firstweek])

Group                String

Description       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.

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

vbUseSystem       0 Use the systems first week of the year.

vbFirstJan1          1 The week that January 1 occurs in. This is the default value.

2                         vbFirstFourDays The first week that has at least four days in the year.

See Also            Predefined Date Format, Predefined Number Format, User defined Date Format, User defined Number Format, User defined Text Format.