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