When we export contacts, we would find that the format for the Created column (date) the contact/s entered the system isn't recognized by our Excel or Google Sheets, perhaps due to the extra timezone (e.g. +00:00) on this format:
2024-12-30T17:04:19+00:00
Because of this, the spreadsheet format somehow doesn't recognize this and be able to change this format into another
1) It would be great if we could change this date & time format:
2024-12-30T17:04:19+00:00
into a more readable
2024-12-30T17:04:19
2) or it would also be good to have the option to select which date (& time) format these would render on the export.
The goal is to have the spreadsheet software recognize this (without any manual formatting) and be able to change this date into other date & time formats. Thanks!