Constructing number formats

Number formats are built up out of hash signs (#), punctuation marks and zero characters, and alphanumerical characters. Click on the arrow at the right of the Number format definition box, and you will see a list of pre-defined number formats:

See the following for more details of how to build number formats and express particular types of number:

Hashes and zeroes

Positive and negative numbers

Including text strings in number formats

Precision

Expressing Roman numerals

Scientific number formats

Engineering format

Percentage

Foreign formats