Microsoft Excel, as a program of North American origin, sets the format of the dates in the American format of default foram. Fortunately, changing the Excel date format to Spanish mode is possible through the program's options in both the desktop version and the online version. A few months ago we made a compilation of 20 free Excel school timetable templates and 100 keyboard shortcuts for Word and Excel. This time we teach you to change the American date format to Spanish in Excel in a simple way.
How to change date format from yyyymmdd to ddmmyyyy in Excel
Changing the date format in Excel is a very simple process. To do this, the first step will be to verify that Microsoft Excel has identified the date cells as Date data to subsequently make the respective changes.
In this case, all we have to do is verify that the program shows the word Date in the box where the type of data is indicated with the cell or cells of the selected date. In case it is shown in white, we will have to click on it and select Date manually.
Once Microsoft Excel detects that it is facing a Date type data, we will select all the cells with dates and we will right click on them to click on Format cells .
In the Number section the Date option will be indicated along with a multitude of date formats to choose from. The one that interests us is the one that shows the usual Spanish date format , which in general is like this:
- 3/14/12 (ddmmyyyy or day, month and year)
We can also choose other date formats in Spanish such as the following:
- Wednesday, march 14, 2012
- March 14, 2012
We just have to click on the format in question and click OK so that the changes are applied to all the affected cells. They will automatically be changed to the new Spanish date format as long as we have indicated it.