Format Property
The Format property sets or returns the format
for numeric values.
Syntax
object .Format
Applies To
Discussion
Use this property to specify a format for numeric values. PowerPlay® uses the formatted values in PowerPlay reports. You must enclose the format string in quotation marks ("").
To add decimal places to a measure value, use the FormatDecimals property.
The available formats are listed below. Several of the format features, such as the currency symbol and thousands separator, may change depending on the properties you set in the regional settings of the Windows control panel.
| Format |
Example |
|---|---|
| 0 |
1000000 |
| #,##0 |
1,000,000 |
| $0 |
$1000000 |
| $#,##0 |
$1,000,000 |
| 0% |
100% |
| %0 |
%100 |
| 0E+00 |
1E+09 |
| 0K |
1000K |
| #,##0K |
1,000K |
| K0 |
K1000 |
| K#,##0 |
K1,000 |
| $0K |
$1000K |
| $#,##0K |
$1,000K |
| 0M |
1000M |
| #,##0M |
1,000M |
| M0 |
M1000 |
| M#,##0 |
M1,000 |
| $0M |
$1000M |
| $#,##0M |
$1,000M |
Type
String
Access
Read/Write
Examples
objMeasures
= objModel.MeasurescurrentMeasure = objMeasures("Revenue")currentMeasure.Format
= "$#,##0"