Format$ Function
Syntax
Format[$](expr[, form$], [firstday], _[firstweek])
Group
Description
Return the formatted string representation of expr.
Parameters
| Parameters | Description |
|---|---|
| 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 vbSunday is used. |
| firstweek | Format using this week as the first week of the year. If this is omitted then vbFirstJan1 is used. |
| 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 | 2 | The first week that has at least four days in the year. |
| vbFirstFullWeek | 3 | 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