Is there a way to format the numbers displayed in the datatable

[sureshcd10]

Is there a way to format the numbers displayed in the datatable.

 

Suppose I am reading a 16digit number from from Excelsheet and getting this on to a Datatable for binding on to a Datagrid.

But when that 16 digit number gets into DataTable say (1234567890123450 ) will automatically gets formatted as 1.23457E+15.

 

 

But I want to retrieve the number 1234567890123450 as 1234567890123450

itself not as 1.23457E+15

 

Any help will be greatly appreciated :confused: :confused:

[PlausiblyDamp]

The data table will just store the value, formatting is down to whatever UI is displaying the data. If you are using a DataGrid then this can be hadled via a DataGridColumnStyle