Data retrieve Format from Excel
I am facing an issue I export excel sheet from my application, the format of data on application is displayed in i.e "31 Jul 09 06:07" and same is displayed in excel sheet, but when i fetch data from excel its displayed in "7/31/2009 6:07:55 AM" format. I want to compare the two is there a way when i do objSheet.Cells(k,2).Value it shud display the displayed format from excel.
Re: Data retrieve Format from Excel
Use the "FormatDate" function to have the date in the required format.