FIXED (PQL  xl)
This function rounds a number to the specified number of decimal places, formats the number in decimal format using a period and commas (if so specified), and returns the result as text
 Library: PQL \ Spreadsheet \ Text
 Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
FIXED(number, OPTIONAL decimals, OPTIONAL no commas)
Function Arguments
Name  Description  Type  Optional 
number  Number to round and convert to text  Number 

decimals  Number of decimal places; if omitted, uses two places  Number  Y 
no commas  Logical value whether not to use commas; if omitted or FALSE, returns with commas  StringOrNumber  Y 
Comments
This function is the same as the Microsoft Excel 'FIXED' function  using the same inputs, logic and outputs.