using Range.NumberFormat

sundar k replied to Arun Kumar at 08-May-08 09:11

lets say  you want to set the Row 1, Col1 cell datatype to Date, then below code can help you out to set the cell datatype to date format,

Excel.Range rg = (Excel.Range)worksheetobject.Cells[1,1];
rg.NumberFormat = "MM/DD/YYYY";


Click here to sign in and reply. You could earn money via our $500 contest just for being helpful.
  How to change the excel shet column as Date Type through C# - Arun Kumar  08-May-08 08:26 8:26:04 AM
      using Range.NumberFormat - sundar k  08-May-08 09:11 9:11:02 AM
          Re: Sundar - Arun Kumar  09-May-08 06:44 6:44:29 AM
              using Range.EntireColumn - sundar k  09-May-08 11:21 11:21:00 PM
      excel shet column - Rakesh Vikram  19-May-08 06:48 6:48:22 AM
View Posts