Last post Mar 14, 2011 10:37 AM by Lannie
Mar 14, 2011 04:28 AM|uma1234|LINK
Actually i wanted to capture Excell Sheet cell data(10/02/2011) and convert this date formatt into DateTime formatt( 10-Feb-2011 h:mm:ss ) and place it into same Excell sheet cell value...
Plz help me outinconverting......
Mar 14, 2011 10:37 AM|Lannie|LINK
Excel, behind the scenes, stores date and time as a DOUBLE number.
What you see on the screen is purely FORMATTING done by the Excel cell format.
You can use an Excel CUSTOM cell format to display the date as dd-MMM-yyyy HH:mm:ss