Platforms to show: All Mac Windows Linux Cross-Platform

Back to XLFormatMBS class.

Previous items

XLFormatMBS.NumformatCustomDMon = 16

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

custom date value: 11-Mar

XLFormatMBS.NumformatCustomDMonYY = 15

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

custom date value: 11-Mar-09

XLFormatMBS.NumformatCustomH0MMSS = 46

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

custom time value: 20:30:55

XLFormatMBS.NumformatCustomHMM = 20

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

custom date value: 8:30

XLFormatMBS.NumformatCustomHMMAM = 18

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

custom date value: 8:30 AM

XLFormatMBS.NumformatCustomHMMSS = 21

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

custom date value: 8:30:00

XLFormatMBS.NumformatCustomHMMSSAM = 19

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

custom date value: 8:30:00 AM

XLFormatMBS.NumformatCustomMDYYYYHMM = 22

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

custom datetime value: 3/11/2009 8:30

XLFormatMBS.NumformatCustomMMSS = 45

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

custom time value: 30:55

XLFormatMBS.NumformatCustomMMSS0 = 47

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

custom time value: 30:55.0

XLFormatMBS.NumformatCustomMonYY = 17

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

custom date value: Mar-09

XLFormatMBS.NumformatDate = 14

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

date value, depends on OS settings: 3/11/2009

XLFormatMBS.NumformatFractionOneDig = 12

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

fraction value, one digit: 10 1/2

XLFormatMBS.NumformatFractionTwoDig = 13

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

fraction value, two digits: 10 23/95

XLFormatMBS.NumformatGeneral = 0

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

general format

XLFormatMBS.NumformatNumber = 1

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

general number: 1000

XLFormatMBS.NumformatNumberD2 = 2

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

number with decimal point: 1000.00

XLFormatMBS.NumformatNumberD2SepNegbra = 39

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

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
One of the number format constants.

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
One of the number format constants.

number with thousands separator: 100,000

XLFormatMBS.NumformatNumberSepD2 = 4

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

number with decimal point and thousands separator: 100,000.00

XLFormatMBS.NumformatNumberSepNegbra = 37

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

number with thousands separator, negative in brackets: (4,000)

XLFormatMBS.NumformatNumberSepNegbraRed = 38

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

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
One of the number format constants.

percent value, multiply the cell value by 100: 75%

XLFormatMBS.NumformatPercentD2 = 10

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

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
One of the number format constants.

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
One of the number format constants.

text value

Previous items

The items on this page are in the following plugins: MBS XL Plugin.


💬 Ask a question or report a problem
The biggest plugin in space...