Data types

Each column has a data type: text, whole or decimal number, date, date/time, Boolean. A correct type determines calculations, sorting and relationships; a date read as text or a number imported as text is a common error to fix.

Example

A "Montant" column imported as text cannot be summed until it is converted to a number.

Related concepts

The whole glossary