Formats a real number as text.
Format
— Whether to treat the number as a generic decimal number, or a percentage (input ranging from 0 to 1, representing 0% to 100%), or a currency amount (including your system’s currency symbol, from your Language & Region settings). Negative currency amounts are formatted within parenthesis, not with a negative number sign.Decimal Places
— The number of digits to show to the right of the decimal point. If fewer digits than the original number, the number is rounded. If zero, the output text omits the decimal point. Depending on your system’s Language & Region settings, the decimal point may be .
or ,
or some other character. Trailing zeroes are omitted, except when formatting as currency.Show Thousands Separator
— Whether to show a separator between each group of 3 digits left of the decimal point. Depending on your system’s Language & Region settings, the thousands separator may be .
or ,
or '
or a space or some other character.Keywords: currency, dollar, euro, percentage, round