.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Ava Aiden
Imran Ghani
Thomas Shaw

Home >> Forum >> VB.Net >> Post New QuestionBookmark and Share Subscribe to Forum

how to format date column in excel report

Posted By: Santosh     Posted Date: July 24, 2011    Points:5   Category :VB.Net

i m generating excel report in runtime containing some date columns,but problem is that the date columns are not showing in proper format(dd/mm/yyyy),means from database i m passing the date format as (dd/mm/yyyy) and it is coming correct in msoffice 2007 as (dd/mm/yyy) but if i m printing in msoffice 2003 it's not coming in proper format.

plz help me on this..


Author: Dhiraj Ranka             
Posted Date: July 25, 2011     Points: 20   


If you want the global solution then you can change the system date time format. I mean if it is set to US then it would be MM-DD-YYYY, now can change it to DD-MM-YYYY. Then this will become default format for office whenever it will encounter any date.

Hope this helps.

Thanks & Regards,
Dhiraj Ranka
http://www.twitter.com/dhirajranka | http://www.dhirajranka.com
Author: Narayanan             
Posted Date: July 25, 2011     Points: 20   

try this...
See your Local System Date Format.

Regards, Lakshmi Naraayanan.S
Author: Santosh             
Posted Date: July 25, 2011     Points: 20   


my regional setting date format is (dd/MM/yyyy) and if regional setting problem then why in msoffice 2003,2000 date is coming in one format(dd/mm/yyyy) and in msoffice 2007 is coming in reverse format(mm/dd/yyyy)???????


Author: Sasi Prabhu             
Posted Date: July 29, 2011     Points: 20   

Try to Set the System Date.

Thanks & Regards,
Sasi Prabhu.
Author: Gowthammanju             
Posted Date: July 29, 2011     Points: 20   

keep look at these link as


Thanks & Regards,

Mark if the answer is true

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend