RemoveZeros Property
The RemoveZeros property returns or sets exponential number formats without the preceding zeros after the E. An exponential number with the RemoveZeros set would appear as 2.01E+3. An exponential number with the RemoveZeros not set would appear as 2.01E+03. Returns a Boolean.
Syntax
object.RemoveZeros
object.RemoveZeros = RemoveZeros
Parameter | Type | Description |
RemoveZeros | Boolean | required, True or 1 to trim exponent zeros. False or 0 to show exponent zeros. |
Example 1
This example demonstrates how to return if a label uses remove zeros.
Debug.Print LabelFormat.Format.RemoveZeros
Example 2
This example demonstrates how to set a label to remove the extra zeros.
YAxis1.TickLabels.MajorFormat.RemoveZeros = 1
Used by: AutoLabelFormat object