Hi Laurence,
sorry keep bugging you guys. I have a issue about the format of SUM
For i As Int32 = 0 To 100
xls.Cells(i, 0).PutValue(99)
xls.Cells(i, 0).Style.Custom = “$#,##0.00;($#,##0.00)”
Next
xls.Cells(“A110”).Formula = String.Format("=SUM(A1:A100)")
The cell A110 is not auto formatted as currency. In Ms-Excel, if I format cells as currency, the sum cell will automatically be formatted to currency. Is that possible to fix it?