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.
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.
Note: 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 in the toolbar or with the keyboard shortcut Ctrl + Z (CMD + Z for Mac users).
Number data types have some unique formatting options particularly relevant to numbers, including whether to include a separate for the 1000th place, decimal place configuration, negative numbers and more.
Use 1000 separator
Selecting the checkbox will format your number to include a character for every three digits, known as the thousands separator. The formatting dropdown (below) will let you decide which separator, but it's the difference between this and this .
You can also select how many decimal places to show. Like other spreadsheets, Spreadsheet.com defaults to 2 and does not delete any numerals not shown, simply hides them. For instance, showing two decimal places looks like this , and showing none like this .
In Spreadsheet.com, you can choose from three default formats for negative numbers. Including, the negative sign, parenthesis, or representing negatives in red.
The Format drop-down at the bottom of the update dialog window allows you to customize which characters you use for formatting like the 1000 separator. This is helpful to format for different countries or preferences. For instance to choose to use a comma for the decimal place instead of a period.