Formatting variables
All variables have one of five available formats: Number, Date, Currency, Percent and Boolean.
Number
Date
Currency
Percent
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:
.png?alt=media)
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.
Precision
Human-readable
Negatives
Commas
Magnitude
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.- 1.Right click a variable/s -> Format (or use the keyboard shortcuts); or
2. Hit the Format icon on a variable.
Tip: to edit the format of multiple variables at once by multi-selecting the variables (cmd/ctrl + click, or shift+↑/↓), then doing either of the above.
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.
Last modified 2mo ago