Format Function |
Syntax:
Format[$](expr[, form$], [firstday], [firstweek])
Group:
Description:
Returns the formatted string representation of expr.
Parameters:
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.