hi
i want to put a decimal value with 4 decimal places into cell
i used the below code
excel.Worksheets[0].Cells[i , j].Style.Number = 4;
but it is showing 2 decmalsplaces only, how to set this to 4 decimal places
hi
i want to put a decimal value with 4 decimal places into cell
i used the below code
excel.Worksheets[0].Cells[i , j].Style.Number = 4;
but it is showing 2 decmalsplaces only, how to set this to 4 decimal places
You can try:
excel.Worksheets[0].Cells[i , j].Style.Custom = "#,##0.0000";