Date Format change

[KatiaBravo]

Hello everyone, I am wondering if you could help me changing the format of a date, I have this format mmm dd, yyyy (e.g. "may 20, 2021").
I just need to change it for dd/mm/yyyy.
Heeelp please
Thanks a lot! :D

 

[Joe4]

Welcome to the Board!

A few questions:

1. Is this value entered as text or as a date (if you change the format of the cell, does the value appear to change or not)?

2. Are you using a US or European version of Excel?

 

[KatiaBravo]

Welcome to the Board!

A few questions:

1. Is this value entered as text or as a date (if you change the format of the cell, does the value appear to change or not)?

2. Are you using a US or European version of Excel?

Thanks a ton for your replyyyy!!!!

it is displayed as "General" the first time I open the exported document.

And I think I am using a US version, how to be sure of this? I don't know where to find this info :'(

 

[Joe4]

OK, if the value is in cell A1, you can convert it to a date using:

=DATEVALUE(A1)

and then use any date format you want on it.

 

[KatiaBravo]

OK, if the value is in cell A1, you can convert it to a date using:

=DATEVALUE(A1)

and then use any date format you want on it.

:O Im in shock!! This worked!!!!!
THANK YOU VERY MUCHHHHHHHHHH!!!!!! :D

 

[Joe4]

You are welcome!
Glad I was able to help.

 

[KatiaBravo]

You did help me and a lot!
Thanks for real! Have a great day! :D