Platforms to show: All Mac Windows Linux Cross-Platform
Back to XLFormatMBS class.
XLFormatMBS.NumformatCustomDMon = 16
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
custom date value: 11-Mar
XLFormatMBS.NumformatCustomDMonYY = 15
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
custom date value: 11-Mar-09
XLFormatMBS.NumformatCustomH0MMSS = 46
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
custom time value: 20:30:55
XLFormatMBS.NumformatCustomHMM = 20
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
custom date value: 8:30
XLFormatMBS.NumformatCustomHMMAM = 18
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
custom date value: 8:30 AM
XLFormatMBS.NumformatCustomHMMSS = 21
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
custom date value: 8:30:00
XLFormatMBS.NumformatCustomHMMSSAM = 19
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
custom date value: 8:30:00 AM
XLFormatMBS.NumformatCustomMDYYYYHMM = 22
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
custom datetime value: 3/11/2009 8:30
XLFormatMBS.NumformatCustomMMSS = 45
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
custom time value: 30:55
XLFormatMBS.NumformatCustomMMSS0 = 47
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
custom time value: 30:55.0
XLFormatMBS.NumformatCustomMonYY = 17
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
custom date value: Mar-09
XLFormatMBS.NumformatDate = 14
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
date value, depends on OS settings: 3/11/2009
XLFormatMBS.NumformatFractionOneDig = 12
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
fraction value, one digit: 10 1/2
XLFormatMBS.NumformatFractionTwoDig = 13
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
fraction value, two digits: 10 23/95
XLFormatMBS.NumformatGeneral = 0
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
general format
XLFormatMBS.NumformatNumber = 1
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
general number: 1000
XLFormatMBS.NumformatNumberD2 = 2
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
number with decimal point: 1000.00
XLFormatMBS.NumformatNumberD2SepNegbra = 39
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
number with thousands separator and decimal point, negative in brackets: (4,000.00)
XLFormatMBS.NumformatNumberD2SepNegbraRed = 40
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
number with thousands separator and decimal point, negative is red in brackets: (4,000.00)
XLFormatMBS.NumformatNumberSep = 3
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
number with thousands separator: 100,000
XLFormatMBS.NumformatNumberSepD2 = 4
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
number with decimal point and thousands separator: 100,000.00
XLFormatMBS.NumformatNumberSepNegbra = 37
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
number with thousands separator, negative in brackets: (4,000)
XLFormatMBS.NumformatNumberSepNegbraRed = 38
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
number with thousands separator, negative is red in brackets: (4,000)
XLFormatMBS.NumformatPercent = 9
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
percent value, multiply the cell value by 100: 75%
XLFormatMBS.NumformatPercentD2 = 10
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
percent value with decimal point, multiply the cell value by 100: 75.00%
XLFormatMBS.NumformatScientificD2 = 11
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
scientific value with E character and decimal point: 10.00E+1
XLFormatMBS.NumformatText = 49
Type | Topic | Plugin | Version |
const | XL | MBS XL Plugin | 11.3 |
text value
The items on this page are in the following plugins: MBS XL Plugin.