Spreadsheet: 21742d1209633493-date-formats-incorrect-when-vba-opens-workbook-correct-format2
Sheet: Todays trades

Trade Id | Version | TradeType | Hedge Document | Status | Trade Id | Status | Counterparty | Currency Code | Nominal | Rate | Value Date | Maturity Date | Ticket Id | ExternalId | Version | Entry Date | User Code | Trader | Book Description | Trade Type | Trade Date | Legal Entity | Broker
 |  |  |  |  |  |  |  |  |  |  | 2008-04-30 00:00:00 | 2008-05-01 00:00:00 |  |  |  | 2008-04-29 01:57:00 |  |  |  |  | 2008-04-29 12:00:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-30 00:00:00 | 2008-05-12 00:00:00 |  |  |  | 2008-04-29 03:22:00 |  |  |  |  | 2008-04-29 12:00:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-30 00:00:00 | 2008-05-14 00:00:00 |  |  |  | 2008-04-29 03:23:00 |  |  |  |  | 2008-04-29 12:00:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 03:29:00 |  |  |  |  | 2008-04-29 12:00:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-05-06 00:00:00 |  |  |  | 2008-04-29 04:03:00 |  |  |  |  | 2008-04-29 12:00:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 09:07:00 |  |  |  |  | 2008-04-29 09:07:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 09:08:00 |  |  |  |  | 2008-04-29 09:07:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 09:08:00 |  |  |  |  | 2008-04-29 09:07:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 09:11:00 |  |  |  |  | 2008-04-29 09:10:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 09:11:00 |  |  |  |  | 2008-04-29 09:10:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 09:14:00 |  |  |  |  | 2008-04-29 09:14:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 09:17:00 |  |  |  |  | 2008-04-29 09:17:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 09:17:00 |  |  |  |  | 2008-04-29 09:17:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-05-06 00:00:00 |  |  |  | 2008-04-29 09:24:00 |  |  |  |  | 2008-04-29 09:24:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-05-06 00:00:00 |  |  |  | 2008-04-29 09:26:00 |  |  |  |  | 2008-04-29 09:24:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-05-05 00:00:00 |  |  |  | 2008-04-29 09:27:00 |  |  |  |  | 2008-04-29 09:26:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 09:33:00 |  |  |  |  | 2008-04-29 09:32:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-30 00:00:00 | 2008-05-09 00:00:00 |  |  |  | 2008-04-29 09:34:00 |  |  |  |  | 2008-04-29 09:33:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-30 00:00:00 | 2008-05-02 00:00:00 |  |  |  | 2008-04-29 09:45:00 |  |  |  |  | 2008-04-29 09:43:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-05-06 00:00:00 |  |  |  | 2008-04-29 09:46:00 |  |  |  |  | 2008-04-29 09:45:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-05-07 00:00:00 |  |  |  | 2008-04-29 09:47:00 |  |  |  |  | 2008-04-29 09:47:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 10:01:00 |  |  |  |  | 2008-04-29 10:00:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-30 00:00:00 | 2008-05-30 00:00:00 |  |  |  | 2008-04-29 10:02:00 |  |  |  |  | 2008-04-29 10:01:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 10:03:00 |  |  |  |  | 2008-04-29 10:02:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-30 00:00:00 | 2008-05-30 00:00:00 |  |  |  | 2008-04-29 10:03:00 |  |  |  |  | 2008-04-29 10:02:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-30 00:00:00 | 2008-05-30 00:00:00 |  |  |  | 2008-04-29 10:04:00 |  |  |  |  | 2008-04-29 10:03:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-05-06 00:00:00 |  |  |  | 2008-04-29 10:06:00 |  |  |  |  | 2008-04-29 10:06:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 10:13:00 |  |  |  |  | 2008-04-29 10:13:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-05-06 00:00:00 |  |  |  | 2008-04-29 10:24:00 |  |  |  |  | 2008-04-29 10:23:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-30 00:00:00 | 2008-05-09 00:00:00 |  |  |  | 2008-04-29 10:34:00 |  |  |  |  | 2008-04-29 10:33:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-05-08 00:00:00 |  |  |  | 2008-04-29 10:45:00 |  |  |  |  | 2008-04-29 10:44:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 10:46:00 |  |  |  |  | 2008-04-29 10:45:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 10:46:00 |  |  |  |  | 2008-04-29 10:46:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 10:47:00 |  |  |  |  | 2008-04-29 10:46:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 10:47:00 |  |  |  |  | 2008-04-29 10:47:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 10:52:00 |  |  |  |  | 2008-04-29 10:52:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-30 00:00:00 | 2008-05-01 00:00:00 |  |  |  | 2008-04-29 10:53:00 |  |  |  |  | 2008-04-29 10:51:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-30 00:00:00 | 2008-05-01 00:00:00 |  |  |  | 2008-04-29 10:53:00 |  |  |  |  | 2008-04-29 10:51:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-05-06 00:00:00 |  |  |  | 2008-04-29 10:55:00 |  |  |  |  | 2008-04-29 10:55:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-05-02 00:00:00 |  |  |  | 2008-04-29 10:59:00 |  |  |  |  | 2008-04-29 10:58:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 11:04:00 |  |  |  |  | 2008-04-29 11:03:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-30 00:00:00 | 2008-05-01 00:00:00 |  |  |  | 2008-04-29 11:07:00 |  |  |  |  | 2008-04-29 11:06:00
 |  |  |  |  |  |  |  |  |  |  | 2008-02-05 00:00:00 | 2008-05-16 00:00:00 |  |  |  | 2008-04-29 11:07:00 |  |  |  |  | 2008-04-29 11:06:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-30 00:00:00 | 2008-05-01 00:00:00 |  |  |  | 2008-04-29 11:07:00 |  |  |  |  | 2008-04-29 11:07:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-05-16 00:00:00 |  |  |  | 2008-04-29 11:07:00 |  |  |  |  | 2008-04-29 11:07:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-29 00:00:00 | 2008-04-30 00:00:00 |  |  |  | 2008-04-29 11:11:00 |  |  |  |  | 2008-04-29 11:11:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-30 00:00:00 | 2008-05-30 00:00:00 |  |  |  | 2008-04-29 11:12:00 |  |  |  |  | 2008-04-29 11:11:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-30 00:00:00 | 2008-05-30 00:00:00 |  |  |  | 2008-04-29 11:12:00 |  |  |  |  | 2008-04-29 11:12:00
 |  |  |  |  |  |  |  |  |  |  | 2008-04-30 00:00:00 | 2008-05-01 00:00:00 |  |  |  | 2008-04-29 11:24:00 |  |  |  |  | 2008-04-29 11:23:00