Formatting

Scripting Formulas Formatting
  • FORMAT.ARABIC — Converts a Roman numeral to its Arabic (standard) numeral format.
  • FORMAT.CURRENCY — Formats a number as currency, with proper support for decimals.
  • FORMAT.PERCENTAGE — Formats a decimal number as a percentage. The number 1 is considered to be 100%.
  • FORMAT.ROMAN — Converts an Arabic (standard) numeral to its Roman numeral format.