This page covers a non-latest version of Handsontable.
# Numeric cell type
By default, Handsontable treats all cell values as
string type. This is because the
<textarea> returns a string as its value. There are many cases where you need cell values to be treated as a
number type. The numeric cell type allows you to format displayed numbers nicely and sort them correctly.
To trigger the Numeric cell type, use the option
type: 'numeric' in the
columns array or
Ensure your cell values are numbers and not strings, as Handsontable will not parse strings to numbers.
You can input float-type values in the numeric editor using a dot or a comma as a decimal separator. For example, both
500000,5 will be accepted. You are not able to use a thousands separator in the editor.
You can format the displayed values of the entered numbers using the
numericFormat option. Note that it ** does not influence the way you enter data**.
All the positive and negative integers whose magnitude is no greater than 253 (+/- 9007199254740991) are representable in the