Difference between revisions of "Documentation/How Tos/Calc: FIXED function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
m |
||
(4 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE:FIXED function}} |
+ | {{Documentation/CalcFunc TextTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_FIND_function | ||
+ | |NextPage=Documentation/How_Tos/Calc:_LEFT_function | ||
+ | }}__NOTOC__ | ||
== FIXED == | == FIXED == | ||
Line 6: | Line 11: | ||
=== Syntax: === | === Syntax: === | ||
<tt>'''FIXED(number; decimals; omitseparators)'''</tt> | <tt>'''FIXED(number; decimals; omitseparators)'''</tt> | ||
− | : returns text representing <tt>'''number'''</tt> with <tt>'''decimals'''</tt> decimal places. If <tt>'''omitseparators'''</tt> (optional) is <tt>'''TRUE'''</tt> thousands separators will be omitted. In the absence of <tt>'''omitseparators'''</tt> thousands separators are included. | + | : returns text representing <tt>'''number'''</tt> with <tt>'''decimals'''</tt> decimal places. If <tt>'''omitseparators'''</tt> (optional) is <tt>'''TRUE'''</tt> thousands-separators will be omitted. In the absence of <tt>'''omitseparators'''</tt> thousands separators are included. |
− | : The thousands separator character used is dependent on your locale settings; see | + | : The thousands-separator character used is dependent on your locale settings; see {{menu|Tools|Options|Language Settings|Languages}}. |
=== Example: === | === Example: === | ||
<tt>'''FIXED(1234567.89; 3)'''</tt> | <tt>'''FIXED(1234567.89; 3)'''</tt> | ||
− | : returns <tt>'''1,234,567.890'''</tt> as text, if your locale uses a comma as the thousands separator. | + | : returns <tt>'''1,234,567.890'''</tt> as text, if your locale uses a comma as the thousands-separator. |
<tt>'''FIXED(1234567.89; 3; TRUE)'''</tt> | <tt>'''FIXED(1234567.89; 3; TRUE)'''</tt> | ||
Line 23: | Line 28: | ||
− | {{ | + | {{SeeAlso|EN| |
* [[Documentation/How_Tos/Calc: TEXT function|TEXT]] | * [[Documentation/How_Tos/Calc: TEXT function|TEXT]] | ||
* [[Documentation/How_Tos/Calc: DOLLAR function|DOLLAR]] | * [[Documentation/How_Tos/Calc: DOLLAR function|DOLLAR]] |