| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Datetime CSV format | Excel Discussion (Misc queries) | |||
| Remove Time from DateTime | Excel Discussion (Misc queries) | |||
| datetime format issues when linking access to excel | Excel Discussion (Misc queries) | |||
| autodate and datetime stamp | Excel Worksheet Functions | |||
| datetime in query | Excel Programming | |||
Threaded Mode
