formatNumber Method (Compact 2013)

3/26/2014

Formats the number using the specified format.

Syntax

strValue = oXTLRuntime.formatNumber(dblNumber, bstrFormat);

HRESULT formatNumber(
  double dblNumber,
  BSTR bstrFormat,
  BSTR* pbstrFormattedString
);

Script

bstrFormat
String. Specified formatting characteristics to be applied to the number. See Remarks.

C/C++

bstrFormat
[in] Formatting characteristics to be applied to the number. See Remarks.

Script

String. Returns a string containing the formatted number.

C/C++

Specified formatting characteristics that are applied to the number. Zero or more of the following values can be present.

#	Display only significant digits; does not display insignificant zeros.
0 (zero)	Display insignificant zeros if a number has fewer digits than there are zeros in the format.
?	Add spaces for insignificant zeros on either side of the decimal point so that decimal points align with a fixed-point font. You can also use this symbol for fractions that have varying numbers of digits.
.	Indicate the placement of the decimal point within the format.
,	Display a comma as a thousands separator or scale a number by a multiple of one thousand.
%	Display a number as a percentage of 100.
E-	(Also "e-") Display a number in scientific format (exponential notation). If a format contains a zero (0) or a number (#) to the right of an exponent code, display the number in scientific format and inserts an "E" or "e." The number of zeros or number signs to the right determines the number of digits in the exponent. Place a minus sign by negative exponents.
E+	(Also "e+") Place a minus (-) by negative exponents and a plus sign by positive exponents.

This method applies to the following interface:

Header	msxml2.h, msxml2.idl
Library	uuid.lib