Comment on page

Formatting variables

How to access format options

Hit the Format icon on a variable. To edit the format of multiple variables at once by multi-selecting the variables (cmd/ctrl + click, or shift+↑/↓).

Format types

All variables have one of five available formats: Number, Date, Currency, Percent and Boolean.
For quantities that aren't percentages or currencies. If a quantity can only be a whole number, turn the Integer toggle on.
The number will be formatted as a date. You can enter the date as date(yyyy,mm,dd) or as date(yyyy,mm).
Specify the currency symbol using the input box. Will default to the last used currency symbol
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%".
A variable that can be True or False (1 or 0). Boolean variables will be displayed with a checkbox:

Custom unit formatting

You can also 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.

Additional format options

Format zeroes
Automatic, or specify the number of decimal places or significant figures.
1,000 -> 1k, 1,000,000 -> 1m, etc. Human readable is automatically on.
Accounting negatives i.e. ($100,000) not -$100,000
Red negatives i.e. -$100,000
or both ($100,000)
Comma separators, i.e. 1000 -> 1,000, 10000 -> 10,000, etc. Comma separators are automatically on.
Automatic (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.
Displays cells with 0 values as -, making it easy to spot cells that have non-zero numbers.

Changing the currency symbol for the entire model

To change the currency symbol for the entire model, multi-select (cmd/ctrl + click) all the relevant variables, then hit the format icon on one of the variables, and change the symbol.