TrimExponent Property
TrimExponent returns or sets the trim exponent style. It has a Boolean value. When enabled (set to True), it removes the leading zero in exponential numbers. So 1.23E+05 becomes 1.23E+5.
Syntax
object.TrimExponent
object. TrimExponent =TrimExp
|
Parameter |
Type |
Description |
|
TrimExp |
Boolean |
required |
Example 1
This example demonstrates how to get the trim exponent value.
Debug.Print LabelFormat.TrimExponent
Example 2
This example demonstrates how to set the trim exponent style.
LabelFormat.TrimExponent = True
Used by: LabelFormat object