Thread: Format dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tamer Seoud Tamer Seoud is offline
external usenet poster
 
Posts: 4
Default Format dates

Hi all,
I have an access Query that I output to excel. There are
two fields that I want to change the format to
(mm/dd/yyyy) once the excel file opens. What is the code I
shall use in VBA editor in Excel to accomplish this?? What
shall I do once I write the code in Excel, so the excel
file opens with the format I specified??
Thanks in advance
Tamer