<numFmt> (Number Format)

This element specifies number formatting for the parent element.

Parent Elements

<catAx> (§5.7.2.25); <dateAx> (§5.7.2.39); <dLbl> (§5.7.2.47); <dLbls> (§5.7.2.49); <serAx> (§5.7.2.176); <trendlineLbl> (§5.7.2.213); <valAx> (§5.7.2.227)

Attributes

Description

<formatCode> (Number Format Code)

This element specifies a string representing the format code to apply. For more information see the SpreadsheetML <numFmt> element's (§3.8.30) @formatCode attribute.

The possible values for this attribute are defined by the ST_Xstring simple type (§5.7.3.52).

<sourceLinked> (Linked to Source)

Specifies a boolean value for the property defined by the parent XML element.

A value of on, 1, or true specifies that the property is applied. This is the default value for this attribute, and is implied when the parent element is present, but this attribute is omitted.

A value of off, 0, or false specifies that the property is not applied.

The possible values for this attribute are defined by the XML Schema boolean datatype.

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_NumFmt">
	<attribute name="formatCode" type="ST_Xstring" use="required"/>
	<attribute name="sourceLinked" type="xsd:boolean"/>
</complexType>