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