
However, the application shall put a space for insignificant zeros on either side of the decimal point so that decimal points are aligned in the column. This symbol follows the same rules as the 0 symbol. However, the application shall not display extra zeros when the number typed has fewer digits on either side of the decimal than there are # symbols in the format. The following table describes the different symbols that are available for use in custom number formats.ĭigit placeholder. The & (ampersand) text operator is used to join, or concatenate, two values. The fourth, and last, section, "Format for text", is the format code that applies to the cell when the cell value is text.

The third section, "Format for zeros", is the format code that applies to the cell when the cell value is zero. The second section, "Format for negative numbers", is the format code that applies to the cell when the cell value contains a negative number. The first section, "Format for positive numbers", is the format code that applies to the cell when the cell value contains a positive number. To skip a section, the ending semicolon for that section shall be written. If only one section is specified, it is used for all numbers. If only two sections are specified, the first is used for positive numbers and zeros, and the second is used for negative numbers.


The format codes, separated by semicolons, define the formats for positive numbers, negative numbers, zero values, and text, in that order. Up to four sections of format codes can be specified. The XML expressing this format shows that the formatId is "166" and the decoded formatCode is $#,#0.00
#Open office date format in text how to#
This element defines the number formats in this workbook, consisting of a sequence of numFmt records, where each numFmt record defines a particular number format, indicating how to format and render the numeric value of a cell.
