Hi all,
I'm a little stumped on this, I have a spreadsheet and all the dates in column B are show in the format of 6th Nov 2021 etc, I would like to change the format to 6-11-2021, I have tried formatting them in format cells selecting the date etc but this dosnt work, I have also tried the text to columns function which didnt work either, im running office 365, would anyone have an idea or VBA code to change this, thanks again
I'm a little stumped on this, I have a spreadsheet and all the dates in column B are show in the format of 6th Nov 2021 etc, I would like to change the format to 6-11-2021, I have tried formatting them in format cells selecting the date etc but this dosnt work, I have also tried the text to columns function which didnt work either, im running office 365, would anyone have an idea or VBA code to change this, thanks again