Have a spreadsheet where the date format appears as 21/03/2018.
I am trying to change it to 21-Mar-2018, but nothing I do works. I have tried copying the date to a blank cell and formatting, I have tried Date formula, Datevalue, and several other tricks I know.
It doesn't appear the original input is text -- so I don't know what the issue could be.
Any thoughts/tips???
I am trying to change it to 21-Mar-2018, but nothing I do works. I have tried copying the date to a blank cell and formatting, I have tried Date formula, Datevalue, and several other tricks I know.
It doesn't appear the original input is text -- so I don't know what the issue could be.
Any thoughts/tips???