New to Kendo UI for jQuery? Start a free 30-day trial

Format

methods

Gets or sets the format of the cells.

format

Returns:String

the format of the top-left cell of the range. When used as a setter, format returns the Range object to allow chained calls.

<div id="spreadsheet"></div>
<script type="text/javascript" charset="utf-8">

    $("#spreadsheet").kendoSpreadsheet();

    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");

    var sheet = spreadsheet.activeSheet();

    sheet.range("A1").value(12.3456).format("#.###");
</script>