Hi all,
I have a date that is being imported into my spreadsheet and comes as a long text that I want to convert to dd/mm/yyyy
An example of how it is imported is this "Monday 3rd Jun, 2:10:40pm"
What I want to do is get rid of the time and convert to just dd/mm/yyyy.
Is there a way to do this?
Thanks in advance,
Tom
I have a date that is being imported into my spreadsheet and comes as a long text that I want to convert to dd/mm/yyyy
An example of how it is imported is this "Monday 3rd Jun, 2:10:40pm"
What I want to do is get rid of the time and convert to just dd/mm/yyyy.
Is there a way to do this?
Thanks in advance,
Tom