Difference between revisions of "Documentation/DevGuide/OfficeDev/Number Formats"

Revision as of 10:25, 4 June 2008

Number formats are template strings consisting of format codes defining how numbers or text appear, for example,, whether or not to display trailing zeros, group by thousands, separators, colors, and how many decimals are displayed. This does not include any font attributes, except for colors. They are found wherever number formats are applied, for example, on the Numbers tab of the Format – Cells dialog in spreadsheets.

Number formats are defined on the document level. A document displaying formatted values has a collection of number formats, each with a unique index key within that document. Identical formats are not necessarily represented by the same index key in different documents.