Number

  • Updated

The Number data type mceclip1.png 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. 

mceclip2.png

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.

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.

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 mceclip0.png or with the keyboard shortcut Ctrl + Z (CMD + Z for Mac users).

Number Formatting

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 mceclip8.png 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 mceclip2.png and this mceclip3.png.

Decimal places

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 mceclip2.png, and showing none like this mceclip4.png.

Negative numbers

In Spreadsheet.com, you can choose from three default formats for negative numbers. Including, the negative sign, parenthesis, or representing negatives in red. 

mceclip5.png

Format drop-down

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.

mceclip7.png

In addition to numbers, Spreadsheet.com has unique data types for currency, dates, duration, and more. Check out our many other custom data types.