Hello, I've searched but I can't find guidance on the specific date and time format issue I have.
I have a spreadsheet with cells in range A2:A100 showing the following date and time format: Tue Jul 17 18:55:29 AEST 2018
I would like a macro to convert this to format: DD/MM/YYYY HH:MM:SS PM
Can someone help me with this please?
Thanks.
I have a spreadsheet with cells in range A2:A100 showing the following date and time format: Tue Jul 17 18:55:29 AEST 2018
I would like a macro to convert this to format: DD/MM/YYYY HH:MM:SS PM
Can someone help me with this please?
Thanks.