An object for formatting numbers in a currency format.


CurrencyFormatis a coclass that formats numbers to look like a currency. For example, the number 123456.789 when formatted with CurrencyFormat(default U.S. English regional settings) would look like $123,456.79. Note that the formatted number is rounded to the nearest cent. Negative numbers are typically depicted inside parentheses, e.g., a negative number of the same value would be formatted as ($123,456.79).

To format numbers as currency, create a CurrencyFormatobject and use the ValueToStringmethod.

Supported Platforms

Windows, Solaris, Linux


Interfaces Description
IClone Provides access to members that control cloning of objects.
INumberFormat Provides access to members that format numbers.
INumberFormatOperations Provides access to common operations on formatted numbers.


CurrencyFormatdoes not have an ICurrencyFormatinterface because there are no member properties to set. To use it, define an object as an INumberFormatand set it to a New CurrencyFormat. You can access the ValueToString****and StringToValue methods directly from this object.

Numbers are formatted using the current regional settings defined for the system at runtime. To change the way currency numbers are formatted, change the settings on the _Currency_tab of Control Panel's _Regional Settings_applet.

Your browser is no longer supported. Please upgrade your browser for the best experience. See our browser deprecation post for more details.