DateFormt To string format (Export To Excel)

A

Agnes

dim strPeriod as string = dtTransdate.ToString("dd-MMM-yyyy",
System.Globalization.DateTimeFormatInfo.InvariantInfo)

'--excel code
..Range("H2").Value = strPeriod

When I read the excel, the column show "Apr-06" , seems correct , however
( it is a date format column), I try to change into string format in excel
but still fail.

Then , I try to put "'"
..Range("H2").Value = "'" & strPeriod
It is string format in Excel BUT when user do some sorting . (it change back
into date format as shown as 01-Apr-2006 or 808354 (some strange integer)

Please help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to change the "Short Date" format in Excel? 4
How to convert user-defined custom format date string to date value 1
Convert VB6-style Date Format string to VB2005-style Date Format string? 2
best approach to extract from long string tables and other info 2
Excel date format YYYYMMDD 1
Convert.ToDateTime ERROR 4
MySQL date format 1
ASP.NET web application - date conversions UK date format? 7

Top