Problem edit currency on datagrid

[noerone]

I am using a DataGrid to call a column from a database with the results that I have modified. suppose the original data is 12000 and after my modifications to 12,000.00 (without changing the data in the database).

But if I want to edit the data in the DataGrid with the "editing in the DataGrid" why when clicked 2x the value changed to 12 and not 12000. Is there a way so that when I click 2x then the value is automatically changed to 12000?

please help me
thank you

[stworthy]

Don't change the value to '12,000.00'. It will be acted as '12' when parsing as decimal value. Please use 'formatter' function to format the original value(12000) to '12,000.00'.

[yupengfei]

Code:

 columns:[[   
          {field:'price',title:'Price',width:100, formatter:function(value,rowData,rowIndex){
			return value + "";
		  }}
      ]]