NumberFormatType complexType

Specifies the number format that should be in cells. The default value is General. All other number formats require a custom format code.

Type Information

Namespace urn:schemas-microsoft-com:office:spreadsheet
Schema name XML Spreadsheet 2002

Elements and Attributes

Child Elements

None.

Attributes

Attribute Type Required Description Possible Values
Format Anonymous optional Specifies a number format code in the Excel number format syntax.

Definition

      
<xsd:complexType name="NumberFormatType" >
  <xsd:attribute form="qualified" name="Format" use="optional" default="General">
    <xsd:simpleType>
      <xsd:union memberTypes="xsd:string">
        <xsd:simpleType>
          <xsd:restriction base="xsd:string">
            <xsd:enumeration value="General" />
            <xsd:enumeration value="General Number" />
            <xsd:enumeration value="General Date" />
            <xsd:enumeration value="Long Date" />
            <xsd:enumeration value="Medium Date" />
            <xsd:enumeration value="Short Date" />
            <xsd:enumeration value="Long Time" />
            <xsd:enumeration value="Medium Time" />
            <xsd:enumeration value="Short Time" />
            <xsd:enumeration value="Currency" />
            <xsd:enumeration value="Euro Currency" />
            <xsd:enumeration value="Fixed" />
            <xsd:enumeration value="Standard" />
            <xsd:enumeration value="Percent" />
            <xsd:enumeration value="Scientific" />
            <xsd:enumeration value="Yes/No" />
            <xsd:enumeration value="True/False" />
            <xsd:enumeration value="On/Off" />
          </xsd:restriction>
        </xsd:simpleType>
      </xsd:union>
    </xsd:simpleType>
  </xsd:attribute>
</xsd:complexType>


    
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp