Previous chapterNext chapter Show allShow all    Hide allHide all

The function fixed (num, decimals, no_seps) formats a number, optionally with seperator (no_seps=0) and converts it to a string.

Syntax: =fixed(num, decimals, no_seps)

num: Numerical value or cell reference

decimals: Number of decimals


Example Example

Cell A1 = 12345.672

=fixed(A1,2,0) is 12.345,67

The separator '.' depends on the regional settings

=fixed(A1,1,1) is 12345,6