Hi I am trying to read from an excel file to my asp.net pages. Everything displays fines except the column the has decimal values in it. In my excel files I am restricting the Cell format to only show 2 decimal but some how when I read this in to my asp page it display all the decimals... I want to truncte the values to 2 decimals only can some one guide me how to do this...the code I using to display an excel file in asp is as follows: private void Page_Load(object sender, System.EventArgs e) { DataSet myDataSet = new DataSet(); string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\exceltest.xls;" + "Extended Properties=\"Excel 8.0;\""; OleDbDataAdapter myData = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn); myData.TableMappings.Add("Table", "ExcelTest"); myData.Fill(myDataSet); dgrdSample.DataSource = myDataSet.Tables[0].DefaultView; dgrdSample.DataBind(); } how can I trucate the output to 2 decimals...I am using C# to code... Will appreciate any help...Thanks

The problem is not with the grid but with the query. Try the select Query as : 'SELECT ROUND(<<COLUMN_NAME>>,2) FROM .... WHERE ....' Here 2 is the decimal precision (2 digits after the decimal pt). Regards, Gaurish

Thanks Gaurish....That was a lot of help....I just had one more question if you could help me out.... 'SELECT ROUND(<<COLUMN_NAME>>,2) FROM .... WHERE ....' with this I am only able to select one Column, do you happen to know the syntax to either do all columns from the sheet or do more then one column...Thanks