Microsoft Excel Experts?
I need some help with some date formatting/conversions. Screenshot is below. this is a small snapshot of the whole worksheet, but its the same throughout. Basically I need the whole column(s) to match, in the exact same format, with date and time. So, taking the first 2 rows for example, row 1 shows 14:16:28 on 28th March 2017. Row 2 shows 25th May, 2017, the time being 06:38:47 seconds, but completely different formatting. Any ideas how I do this?