Hello
I'm just trying to fill up Excel file with numbers at runtime. Below is piece of code:
ExcelApp.Cells[iRow, iCol].NumberFormat = "F0"; //also "G" "F2" has been used
ExcelApp.Cells[iRow, iCol].Value = strNumber; //it's in European notation like 11,23 15334,67 189 and so on
If the number is whole it's OK, but when it has fraction it's being treated as text and can't be used to autosum. Why?
Sorry for no file, this forum does not allow to add attachment