When we are setting the value of a cell we are losing formatting €“ is there
anyway we can retain the cell formatting

r.set_Value(Excel1.XlRangeValueDataType.xlRangeVal ueDefault, factValue); //
factValue is string

r.Cells.NumberFormat =
Thread.CurrentThread.CurrentCulture.NumberFormat.N umberDecimalSeparator ;


Is there anything else needs to be done ?


Thanks