Thread: DateTime Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe Harriman Joe Harriman is offline
external usenet poster
 
Posts: 1
Default DateTime Format

I need to know the available formats for date and time.
I am interested in the Data ss:Type='DateTime'. This
type show my dates in the YYYY-MM-DDTHH:MM:SS.000 format.
Is there anyone who can tell me what to use to show my
dates as MM/DD/YYYY HH:MM AM ????
I can bring up the Command and Options window and change
it in Excel, but I want to show it this way when I create
it.

Thanks for any help.