Formatting variables

There are five main format types for variables: Number, Currency, Date, Percent, and Boolean. You can access the format type from the icon to the left of the variable name, or the pencil icon to the right.

  • Number #️⃣ : For quantities that aren't percentages or currencies.
  • Date 📆 : The number will be formatted as a date. You can enter the date as date(yyyy,mm,dd) or as date(yyyy,mm).
  • Currency $: Choose a specific currency (e.g. USD), or select "Custom" if the currency is not listed (e.g. cryptocurrencies). The currency symbol for common currencies is pre-set from the currency you select (e.g. $ for USD), but you can manually change the prefix/suffix.
  • Percent % : This expects the variable's value to be a decimal. Example: 0.5 will be displayed as 50%. You can also enter directly as "50%".
  • Boolean ☑️: A variable that can be True or False (1 or 0), displayed as a checkbox/toggle.

Additional format options

You can find these by hitting the pencil to the right of the variable name -> Format.

Custom prefix/suffix (i.e. custom units)

You can set custom unit formats for your variables, and set whether that unit is displayed before or after the number (prefix vs. suffix).

This gives you ultimate flexibility to visually distinguish the units of variables in your models (e.g. currencies, earnings multiples, ratios, time units etc). Note that custom units are purely visual and do not affect calculations whatsoever.

Other advanced formatting options

PrecisionAutomatic, or specify the number of decimal places or significant figures.
Human-readable1,000 -> 1k, 1,000,000 -> 1m, etc. Human readable is automatically on.
NegativesAccounting negatives i.e. ($100,000) not -$100,000 Red negatives i.e. -$100,000 or both ($100,000)
CommasComma separators, i.e. 1000 -> 1,000, 10000 -> 10,000, etc. Comma separators are automatically on.
MagnitudeAutomatic (as entered), or specify the 'unit' (thousand, lakh, million, crore, billion, trillion) you want to display the value in. For example, if you entered 100 but format the display as 'thousand', this will be 0.1k.
Format zeroesDisplays cells with 0 values as -, making it easy to spot cells that have non-zero numbers.