Format$ Function
Syntax
Format[$](expr[, form$], [firstday], [firstweek])
Group
Description
Return the formatted string representation of expr.
Parameters |
Description |
Return the formatted string representation of this numeric value. |
|
Format expr using to this string value. If this is omitted then return the expr as a string. |
|
Format using this day as the first day of the week. If this is omitted then vbSunday is used. |
|
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, SymbolInfo Format, User defined Date Format, User defined Number Format, User defined Text Format