Format

Overview

Formats the value according to the string you specify.

Syntax

Format(1, 2, 3, 4)

Function Properties

OrdinalTypeDescription
1stringRequiredVariable to format
2stringRequiredA C# compatible format string:
  • MM/dd/yyyy
  • Cn - currency format where n represents the number of decimal places
3stringIndicates data format of value. Valid values include Date and Number.
4stringCulture code used to indicate the correct date format.

Usage

There are multiple possibilities for displaying the date using this function.

For more information on formatting numeric strings, see the Microsoft help regarding the NumberFormatInfoClass.

Example 1

System returns today's date in MM/dd/yyyy format.

Example 2

Example 3

System returns the formatted date localized for fr-FR.

Microsoft Help Regarding the DateTimeFormatInfo Class

Microsoft Help Regarding the NumberFormatInfoClass Class