XlDisplayUnit enumeration (Office)

Indicates numeric units of measurement.

Name Value Description
xlDisplayUnitCustom -4114 Specifies custom units.
xlDisplayUnitNone -4142 No units are displayed.
xlHundredMillions -8 Specifies units of hundreds of millions.
xlHundreds -2 Specifies units of hundreds.
xlHundredThousands -5 Specifies units of hundreds of thousands.
xlMillionMillions -10 Specifies units of millions of millions.
xlMillions -6 Specifies units of millions.
xlTenMillions -7 Specifies units of tens of millions.
xlTenThousands -4 Specifies units of tens of thousands.
xlThousandMillions -9 Specifies units of thousands of millions.
xlThousands -3 Specifies units of thousands.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.