You will get an overview which number formatting options are possible in the application.
Dots as a separator for thousand
You can use dots as separators for thousand, but they must appear in the correct place when used.
Error message:
Correct formatting:
Comma as a decimal separator
A maximum of one comma may be used as a decimal separator. There must be at least one digit before and after the comma.
Incorrect input:
Correct input:
Cell functions
Cell functions can be used. More about cell functions.
Minus sign
You may use a maximum of one preceding minus.
A minus sign must not be used with a cell function in the same cell from a form.
Error message with two minus signs:
Example:
Formatting with units
The string belonging to the value type of the cell to be changed may be used after the number. Each cell has exactly one of 5 possible value types. The owner can define a string as a unit for each of these value types.
Example:
For the value type "Price" the string "EUR" could have been defined and for the value type "Percentage" the string "%". Then the input "3EUR" would be allowed for a "Price" cell. Forbidden for the same cell would be "3€" or "3$" because these are not the specified string in each case, and "3%" is also not allowed because it is not a "percentage" cell. When you leave the cell, we format the number as specified by the owner, from this you can read the correct string.
There may be any number of spaces between the number and the string.
Example:
Multiplying numbers using K or M
The characters K and M serve as abbreviations for thousands and millions.
Multiply with thousand (K)
<number>K or <number>k multiplies <number> with 1.000
Before:
After:
Multiply with million (M)
<number>M or <number>m multiplies <number> with 1.000.000
Before:
After:
