The Number data type is for inputting numbers as integers or decimals.

Number fields support positive, negative, and decimal numerals, as well as @mentions, all of which can be made bold, underlined, larger in font size, etc. Number data types are also useful for formulas where the output is a number. For other situations, Spreadsheet.com has custom data types for Currency, Dates, or formulas you want to apply column-wide.

Configuration Options

Strict

Like other data types, Number data types can have Strict enabled. Selecting the Strict checkbox for Number cells will restrict users to input only numeric characters. Also, columns that have Strict enabled cannot have cells of different data types.

Currently, formulas are not allowed in strict Number cells. When there are existing formulas in a column, cell, or range of cells and you change to Strict, those formulas will be converted to the output value. You can always revert by selecting Undo from the top left corner of the toolbar, or by using the keyboard shortcut Ctrl + Z (CMD + Z for Mac users).

Use 1000 separator

Selecting the Use 1000 separator option will format your numbers to include a character after every three digits, known as a thousands separator. You can specify the format of the separator from the Format dropdown at the bottom of the dialog.

Decimal places

Specify how many decimal places will be show. Like other spreadsheets, Spreadsheet.com defaults to 2 and does not delete any numerals not shown and simply hides them.

Negative numbers

You can choose from three default formats for negative numbers, choosing to indicate the values by a sign, by parentheses, or by formatting the number with red text.

Format

The Format dropdown at the bottom of the dialog allows you to customize which characters are used for formatting the thousands separator. This can be helpful to format numbers for different countries or preferences.

In addition to numbers, Spreadsheet.com has unique data types for other numerical values like Currency, Dates, Duration, and more. Or, read on to learn more about the rest of Spreadsheet.com's Data Types.