Thread: opening excel file - date format problem: DD/MM/YYYY vs MM/DD/YYYY
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
broogle broogle is offline
external usenet poster
  
Posts: 67
Default opening excel file - date format problem: DD/MM/YYYY vs MM/DD/YYYY
I think you have to format that cell in your code.

Sheets("mysheet").Range("myrange").Value = Format(Now(), "dd-mm-yy")

Reply With QuoteReply With Quote