How to make correct date format when writing data to Excel

by

Did you try formatting the entire column as a date column? Something like this:

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

The other thing you could try would be putting a single tick before the string expression before loading the text into the Excel cell (not sure if that matters or not, but it works when typing text directly into a cell).

More Related Contents:

  1. How to read an excel file in C# without using Microsoft.Office.Interop.Excel libraries
  2. Importing Excel into a DataTable Quickly
  3. How to save workbook without showing save dialog with Excel interop?
  4. Reading Excel files from C#
  5. How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
  6. Reading Datetime value From Excel sheet
  7. Reading excel file using OLEDB Data Provider
  8. How to read file using NPOI
  9. How to open an Excel file in C#?
  10. EPPlus number format
  11. Read from word document line by line
  12. How to read data from excel file using c# [duplicate]
  13. Get instance of Excel application with C# by Handle
  14. BUG: Can’t choose dates on a DatePicker that fall outside a floating VSTO Add-In
  15. Why does Microsoft.Office.Interop.Excel.Application.Quit() leave the background process running?
  16. The quest for the Excel custom function tooltip
  17. What reference do I need to use Microsoft.Office.Interop.Excel in .NET?
  18. Set data type like number, text and date in excel column using Microsoft.Office.Interop.Excel in c#
  19. How to write an image from byte[] into MS WORD using C# Windows application
  20. Why appending AutoFilter corrupts my excel file in this example?
  21. C# – How to add an Excel Worksheet programmatically – Office XP / 2003
  22. Detecting a password-protected document
  23. How to import all the Excel sheets to DataSet in C#
  24. Scientific notation when importing from Excel in .Net
  25. EPPlus – LoadFromCollection – Text converted to number
  26. Accessing an open Excel Workbook in C#
  27. As of today, what is the right way to work with COM objects? [duplicate]
  28. .Net Excel Interop Deleting a worksheet
  29. Is IDisposable.Dispose() called automatically? [duplicate]
  30. Change ComboBox Border Color in Windows Forms

Leave a Comment