Number_formatting

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:

zahlenformatierung_trennzeichen-1_en

Correct formatting:

zahlformatierung_trennzeichen2-1_en

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:

zahlformatierung_dezimaltrennzeichen_en

Correct input:

zahlformatierung_dezimaltrennzeichen2

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:

zahlformatierung_minus_en

Example:

zahlformatierung_minus2_en

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:

zahlformatierung_einheiten_en

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:

zellfunktion_k-1200x545

After:

zellfunktion_k1-1024x486

Multiply with million (M)

<number>M or <number>m multiplies <number> with 1.000.000

Before:

zellfunktion_m-1024x486

After:

zellfunktion_m1

Category: Formulare Subcategory: Arbeiten mit Formularen Keywords: formatting,number formatting Original Article