How to convert m/d/yyyy string to mm/dd/yyyy to bind excel ?

Sujeet Raman

Hi,

I have a string coming from excel as "8/3/1989" (m/d/yyyy) in below code.I need to convert it in to 08/03/1989 .In excel coloumn the format is text.I alwas getting error after every conversion like input string is not in correct format in. below code I am using

string effdate= xlWorksheet.Cells[i, 8].Value.ToString();
DateTime dt = DateTime.Parse(effdate);
xlWorksheet.Cells[i, 8] = dt.ToString();
xlWorksheet.Cells[i, 8].NumberFormat = "MM/DD/YYYY";

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ganesan C5y ago
Accepted answer
Hi, Convert to required format and assign date with correct format in excel.
```
xlWorksheet.Cells[i, 8] = dt.ToString("MM-dd-yyyy");
```
Meena Bisht5y ago
Hello,

There is a slight change in your code. Please try using this code

string effdate= xlWorksheet.Cells[i, 8].Value.ToString();
DateTime dt = DateTime.Parse(effdate);
xlWorksheet.Cells[i, 8] = dt.ToString("dd/MMM/yyyy");

Thanks & Regards,
Meena Bisht
Abhishek Chadha5y ago
Refer this post -
https://www.c-sharpcorner.com/code/1566/convert-date-time-in-c-sharp.aspx