Version

UltraCalcFunctionFixed Class

Formats a numeric value rounded to a specified number of decimal places and with optional thousands separators.
Syntax
'Declaration
 
Public Class UltraCalcFunctionFixed 
   Inherits BuiltInFunctionBase
public class UltraCalcFunctionFixed : BuiltInFunctionBase 
Remarks

FIXED(value, decimal_places, exclude_thousands_separators)

Value is the numeric value to be rounded and formatted as text.

Decimal_places indicate how many places to the right of the decimal point the value should be rounded. If omitted, rounding occurs to two decimal places.

Exclude_thousands_separators is a boolean value (TRUE or FALSE) indicating whether commas should appear in the formatted text value. By default the formatted text includes commas as thousands separators.

This function may not return text values consistent with your locale's formatting of numbers because it operates using culture invariant settings (these include commas as thousands separators and decimal points) to facilitate unambiguously parsing the text values it formats into numeric values for subsequent calculations. Applications may instead choose to format numeric values after UltraCalc has finished processing them, but before presenting them to their end user.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also