Format Function |
Format[$](expr[, form$], [firstday], [firstweek])
Returns the formatted string representation of expr.
|
Parameter |
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 the vbSunday is used. |
|
|
Format using this week as the first week of the year. If this is omitted then the vbFirstJan1 is used. |
|
firstday |
Value |
Description (Return value range) |
|
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 (Return value range) |
|
vbUseSystem |
0 |
Use the systems first day of the week. |
|
vbFirstJan1 |
1 |
Sunday (default) |
|
vbFirstFourDays |
2 |
Monday |
|
vbFirstFullWeek |
3 |
Tuesday |
See Also:
Predefined Date Format, Predefined Number Format, User defined Date Format, User defined Number Format, User defined Text Format.