Forum Discussion
GetAKitty4465
Oct 29, 2019Copper Contributor
Need Help Sorting This Date/Time Column
I have 8000 text messages that have been imported into Excel. Column A has the date/time and Column B has the text itself. The format of A is: Monday, November 19, 2018 8:43:07 AM Monday, Nove...
GetAKitty4465
Oct 29, 2019Copper Contributor
Thank you for the work you put into that. However, with the time striped out, the text messages might be sorted by the date but the time of when they were sent will no longer be in order since they are no longer being sorted by both date and time. Twifoo
Twifoo
Oct 29, 2019Silver Contributor
The time is still there. Cell H3 didn't show the time simply because the custom format didn't include it. If cell H3 is custom-formatted as "mmmm d, yyyy h:mm:ss AM/PM", then it would also show the time like this: