Tue Jan 18, 2011 7:45 am
You may use following code to set the number format of the range:
sheet.Range[2, 2, 6, 6].NumberFormat = "$#,##0.00";
When you write numbers in the range, it will use the format you
specify, such as:
sheet.Range["C3"].NumberValue = 3240.689;
sheet.Range["D4"].NumberValue = 5230.123;
e-iceblue support