Variable Type

Type declaration

• ReadonlyAccounting: "Accounting"

  Formats numbers as currency, aligning currency symbols and decimal points in a column.

• ReadonlyComma: "Comma"

  Displays numbers with a thousands separator.

• ReadonlyCurrency: "Currency"

  Formats numbers as currency with a currency symbol and two decimal places.

• ReadonlyCustom: "Custom"

  Indicates a user-defined or custom number format.

• ReadonlyFraction: "Fraction"

  Displays numbers as fractions.

• ReadonlyGeneral: "General"

  The default format, displays numbers as entered.

• ReadonlyLongDate: "Long Date"

  Displays dates in a long format (e.g., "dddd, MMMM d, yyyy").

• ReadonlyLongTime: "Long Time"

  Displays times in a long format (e.g., "h:mm:ss.000 AM/PM").

• ReadonlyMediumDate: "Medium Date"

  Displays dates in a medium format (e.g., "d-mmm-yy").

• ReadonlyMediumTime: "Medium Time"

  Displays times in a medium format (e.g., "h:mm:ss AM/PM").

• ReadonlyNumber: "Number"

  Displays numbers with a thousands separator and two decimal places.

• ReadonlyPercentage: "Percentage"

  Displays numbers as percentages with a percent symbol.

• ReadonlyScientific: "Scientific"

  Displays numbers in scientific notation.

• ReadonlyShortDate: "Short Date"

  Displays dates in a short format (e.g., "M/d/yyyy").

• ReadonlyShortTime: "Short Time"

  Displays times in a short format (e.g., "h:mm AM/PM").

• ReadonlySpecial: "Special"

  A placeholder for special or custom number formats.

• ReadonlyText: "Text"

  Treats the cell content as text, even if it appears to be a number.