On the Numberstab (Figure 26), the behavior of the data in the cell can be controlled:
Any of the data types in the Category list can be applied to the data.
The number of decimal places and leading zeros can be controlled.
A custom format code can also be entered.
Using the language setting in this menu controls the local settings for the different formats such as the date order and the currency marker.