Fecha español excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1600546%22%20slang%3D%22es-ES%22%3ESpanish%20date%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1600546%22%20slang%3D%22es-ES%22%3E%3CP%3EInstall%20every%20office%20in%20Spanish%20and%20I%20put%20the%20date%20in%20Spanish%20Mexico%20or%20Latin%20America%2C%20but%20I%20keep%20putting%20the%20date%20and%20changes%20it%20to%20English%26nbsp%3B%3C%2FP%3E%3CP%3EExample%20I%20put%20August%2012%2012%2F08%20and%20when%20you%20give%20enter%20me%20change%20it%20to%2008%2F12%2F20.%26nbsp%3B%20How%20can%20I%20correct%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1600546%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1600568%22%20slang%3D%22de-DE%22%3ESubject%3A%20Fecha%20espa%20ol%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1600568%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765334%22%20target%3D%22_blank%22%3E%40deybelZ%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId-523635692%22%20id%3D%22toc-hId-523635692%22%3E%3CFONT%20size%3D%224%22%3ECambiar%20el%20sistema%2C%20formato%20o%20la%20interpretaci%20n%20de%20los%20a%20os%20de%20dos%20d%20gitos%20de%20las%20fechas%3C%2FFONT%3E%3C%2FH1%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fes-es%2Foffice%2Fcambiar-el-sistema-formato-o-la-interpretaci%25c3%25b3n-de-los-a%25c3%25b1os-de-dos-d%25c3%25adgitos-de-las-fechas-aaa2159b-4ae8-4651-8bce-d4707bc9fb9f%3Fui%3Des-es%26amp%3Brs%3Des-es%26amp%3Bad%3Des%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fes-es%2Foffice%2Fcambiar-el-sistema-formato-o-la-interpretaci%25c3%25b3n-de-los-a%25c3%25b1os-de-dos-d%25c3%25adgitos-de-las-fechas-aaa2159b-4ae8-4651-8bce-d4707bc9fb9f%3Fui%3Des-es%26amp%3Brs%3Des-es%26amp%3Bad%3Des%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId--1283818771%22%20id%3D%22toc-hId--1283818771%22%3E%3CFONT%20size%3D%224%22%3ESistemas%20de%20fecha%20en%20Excel%3C%2FFONT%3E%3C%2FH1%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fes-es%2Foffice%2Fsistemas-de-fecha-en-excel-e7fe7167-48a9-4b96-bb53-5612a800b487%3Fui%3Des-es%26amp%3Brs%3Des-es%26amp%3Bad%3Des%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fes-es%2Foffice%2Fsistemas-de-fecha-en-excel-e7fe7167-48a9-4b96-bb53-5612a800b487%3Fui%3Des-es%26amp%3Brs%3Des-es%26amp%3Bad%3Des%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMe%20encantar%20a%20saber%20si%20puedo%20ayudar.%3C%2FP%3E%3CP%3ENikolino%20%3CBR%20%2F%3E%20Yo%20se%20que%20no%20se%20nada%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Instale todo office en español y pongo la fecha en español mexico o America latina, pero sigo poniendo la fecha y me la cambia a ingles 

Ejemplo pongo 12 de Agosto 12/08 y al dar enter me la cambia a 08/12/20.  ¿Como puedo corregir esto?

1 Reply

@deybelZ 

 

Cambiar el sistema, formato o la interpretación de los años de dos dígitos de las fechas

https://support.microsoft.com/es-es/office/cambiar-el-sistema-formato-o-la-interpretaci%c3%b3n-de-lo...

 

Sistemas de fecha en Excel

https://support.microsoft.com/es-es/office/sistemas-de-fecha-en-excel-e7fe7167-48a9-4b96-bb53-5612a8...

 

Me encantaría saber si puedo ayudar.

Nikolino
Yo se que no se nada (Sócrates)