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


Top 5 Contributors of the Month
david stephan

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
hi

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..

regards
santosh

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

Hi,

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   

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


Regards, Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
Author: Santosh             
Posted Date: July 25, 2011     Points: 20   

hi

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)???????


regards
santosh

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


http://www.pivot-table.com/

Thanks & Regards,
GowthamManju
Chennai



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
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

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