Rounds a number and returns the result as text. You can specify the number of digits to the right of the decimal points. You can also specify whether the result be returned with or without commas.
FIXED (<number>, [<decimals>, [<no_commas>]])
|Sr.No.||Parameter & Description|
The number of digits to the right of the decimal point.
If omitted, 2.
Can be specified only if decimals are specified. Otherwise, should be omitted.
A number represented as text.
If no_commas is FALSE or 0 or is omitted, then the returned text includes commas.
You have two options to format a column containing numbers −
The difference between the two options is that the FIXED function converts its result to text, whereas with the formatting command the result is still a number.
Numbers can never have more than 15 significant digits, but decimals can be as large as 127.
= FIXED ([Sales Amount],2)
26 Lectures 4.5 hours