Change format for date

[sreejesh]

Hi,

I have cell with date in the below format, how do i change the date format to somthing that the excel recognizes as date lik dd-mm-year

       Aug  2 2010 12:00AM

 

[delaneyjm]

Use the custom formatting string of dd-mm-yyyy

 

[sreejesh]

not sure how that works, i need date and time... can you show me a sample code. thanks.

 

[sreejesh]

Hi,

How do i include the date and time in the below code

[HTMLActiveWorkbook.SaveAs Filename:="\\ProjectsFICCS\blrcmo\FI Prematching\Metrics\" & Format(Date, "dd-mmm-yy") & ".xls"][/HTML]

 

[delaneyjm]

Use mmm DD yyyy h:NM AM/PM for your text string