excel shet column

Range rg = worksheet.get_Range("A1","An");

// date data type

rg = (Excel.Range)worksheet.Cells[RowCounter,2];

rg.NumberFormat = "MM/DD/YYYY";

//currency

rg = (Excel.Range)worksheet.Cells[RowCounter,4];

rg.NumberFormat = "$0.00";