Format Function

Syntax:

Format[$](expr[, form$], [firstday], [firstweek])

Group:  

String

Description: 

Returns the formatted string representation of expr.

Parameters:

Parameter

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 the vbSunday is used.

firstweek

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.