A big big hello! , I would like to know how the date of excel can be formatted since I have by default in this way eg: 12-03-2022, and I want it to be like this 2022-03-12, so that later I can import that excel based on of data, and it does not take me the first format so if I try to change it to the second format, (I work with mysql and php), try to change it in excel in this way:
I give it to finish to change the format but no change occurs in the excel, thank you very much in advance!
Well based on the documentation, you can convert your date by applying it from the cell format. For example, suppose I have this date
(dd/MM/yyyy)
and I want it to be(yyyy-MM-dd):
Pressing we will
**ctrl+1**
see the format:Now, all that remains is to find the
formato
one we want to see:We press accept and that's it :