Changing Date Format

[kipper19]

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

 

[Peter_SSs]

im running office 365

Then it might be time to update your account details?

My guess is that the column B values are text values, not numerical. Try this formula and format with the date format you want.

=REPLACE(A2,FIND(" ",A2)-2,2,"")+0

 

[kipper19]

Then it might be time to update your account details?

View attachment 68523

My guess is that the column B values are text values, not numerical. Try this formula and format with the date format you want.

=REPLACE(A2,FIND(" ",A2)-2,2,"")+0

Thanks Peter, that worked and have updated profile

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

.. and for updating your profile.