litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

String - Format

Syntax:
=Format(Expression, FormatString, Optional FirstDayOfWeek As Variant, Optional FirstWeekOfYear)

Description:
Formats an expression according to the format string and options specified. Equivalent to the Visual Basic Format function.

Expression : the value to format
FormatString : the string that denotes the format that should be applied. Use the format strings you use in Visual Basic.
FirstDayofWeek : Optional. This constant specifies which day is considered to be the start of the week. 0 is the system default, 1 is Sunday, 2 is Monday, 3 is Tuesday, and so on.
FirstWeekOfYear : Optional. This constant specifies the first week of the year. If not specified the first week of the year is considered the week of January the 1st.  0 is the system default, 1 is week of January the 1st, 2 starts with the week that has at least 4 days, 3 starts the year with the first full week.

Example:
Format a number as 1.20
=Format(1.2,"0.00")
Format a number with a thousand separator and two decimals
=Format(1000.2,"###,##0.00")
Format a number as percentage
=Format(0.051," 0.00 %")
Format a string as lower case
=Format("HELLO","<")
Format a string as upper case
=Format("hello",">")
Format the current date as a Long Date
=Format(NOW(),"Long Date")
Format the current date and time as a Long Time
=Format(NOW(),"Long Time")