Quantity Fields

A quantity field with an alternate unit
Put the unit shortcut after the number.
Example:
A field with the unit miles and the alternate unit kilometres (shortcut k)
• 110 in the spreadsheet would result in 110 miles (default)
• 110k would result in 110 kilometres (the alternate unit).

A currency field with an alternate currency
Put the currency shortcut after the number.
Example:
A field in American dollars with an alternate currency of Euros
• 110 in the spreadsheet would result in 110 USD (default)
• 110e would result in 110 Euros (the alternate currency).

Quantity fields left blank
The field will have the value 0.