This page covers a next version of Handsontable, and is not published yet.

This page covers a non-latest version of Handsontable.

# Numeric cell type

# Overview

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.

# Usage

To trigger the Numeric cell type, use the option type: 'numeric' in the columns array or cells function.

TIP

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, 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**.

TIP

All the positive and negative integers whose magnitude is no greater than 253 (+/- 9007199254740991) are representable in the Number type, i.e., safe integer. Any calculations that are performed on bigger numbers won't be calculated precisely due to JavaScript limitations.

# Basic example