Thread: Date (dd/mmm/yyyy)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ernie Ernie is offline
external usenet poster
  
Posts: 65
Default Date (dd/mmm/yyyy)
when i put in this code:

txtDate.value = Date

the output format is:

06/09/06 (mm/dd/yy)

how do i modify the code to get the results in this format:

06-Sep-2006 (dd/mmm/yyyy)
Reply With QuoteReply With Quote