Sample: SELECT Id, CreatedDate FROM Account
Result of CreatedDate: 2024-08-14T14:48:05.000+0000
To Convert into Excel as Date/Time format:
- Formula =VALUE(SUBSTITUTE(LEFT(A2, 19), "T", " "))
- Format Cells... (or Ctrl+1) for the above formula cell, select Custom, and Type: yyyy-mm-dd hh:mm:ss
- Done