Number Formats in User Settings

If you need to localise numeric in a CRM Client Side User interface, you'll need to query the UserSettings and use the following properties:

Field

Description

NumberSeparator

The character used to separate number groups for readability as defined by the NumberGroupFormat property detailed below.

E.g. if the NumberSeparator=',' then the number would be formatted:

123,456,789

DecimalSymbol

The character used to separate the decimal part of the number.

E.g. if the DecimalSymbol='.' Then the number would be formatted:

123.456

NumberGroupFormat

Defines the grouping of digits for readability:

 

Value

Result

3

123,456,789.00

3,0

123456,789.00

3,2

12,34,56,789.00

0    

123456789.00

 

NegativeFormatCode

Defines how negative numbers of formatted:

Value

Result

1

-1234567

0

(1234567)

2

- 1234567

3

1234567-

4

1234567 -

CurrencyDisplayOption
(Organization Settings)
Defines how the Currency will be displayed:

Value

Result

0

Currency Symbol (e.g. $12345.00)

1

Currency Code (e.g. USD 12345.00)

 

@ScottDurow

Comments are closed