FormatNumber

FormatNumber

This function formats a string as a number.

Format patterns follow the C# format types outlined in the official Microsoft documentation:

• Standard Numeric Format Strings
• Standard Date and Time Format Strings

Some of these custom formats are supported:

• Custom Numeric Format Strings
• Custom Date and Time Format Strings

Arguments

FormatNumber(1,2,3)

NOTE: By default, this function rounds half up to two decimal places.

Here are a few examples of format patterns, given a number of 123:

NOTE: The D pattern requires an integer for input.

Here are a few examples of custom format patterns, given a number of -1.8967:

Example 1

%%[

var @num
var @Currency
var @Currency3
var @Decimal
var @Exponential
var @Fixed
var @Fixed3
var @General
var @Number
var @Number3
var @Percent
var @Hex

set @num = "123"

set @Currency = FormatNumber(@num, "C")
set @Currency3 = FormatNumber(@num, "C3")
set @Decimal = FormatNumber(@num, "D")
set @Exponential = FormatNumber(@num, "E")
set @Fixed = FormatNumber(@num, "F")
set @Fixed3 = FormatNumber(@num, "F3")
set @General = FormatNumber(@num, "G")
set @Number = FormatNumber(@num, "N")
set @Number3 = FormatNumber(@num, "N3")
set @Percent = FormatNumber(@num, "P")
set @Hex = FormatNumber(@num, "X")

]%%
num: %%=v(@num)=%%
<br><br>Currency: %%=v(@Currency)=%%
<br>Currency3: %%=v(@Currency3)=%%
<br>Decimal: %%=v(@Decimal)=%%
<br>Exponential: %%=v(@Exponential)=%%
<br>Fixed: %%=v(@Fixed)=%%
<br>Fixed3: %%=v(@Fixed3)=%%
<br>General: %%=v(@General)=%%
<br>Number: %%=v(@Number)=%%
<br>Number3: %%=v(@Number3)=%%
<br>Percent: %%=v(@Percent)=%%
<br>Hex: %%=v(@Hex)=%%

Output

num: 123

Currency: $123.00
Currency3: $123.000
Decimal: 123
Exponential: 1.230000E+002
Fixed: 123.00
Fixed3: 123.000
General: 123
Number: 123.00
Number3: 123.000
Percent: 12,300.00 %
Hex: 7B

Example 2

Example 3