fixed |
|
Manual -> Report Generator -> Engineering in the Editor -> Report functions -> Text functions -> fixed |
   Show
all  Hide
all |
fixed |
|
Manual -> Report Generator -> Engineering in the Editor -> Report functions -> Text functions -> fixed |
|
Show
all Hide
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
no-seps:
|
|
|
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 |
Example