Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help String functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - Format function
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")

litLIB