Convertir fecha en cadena de testoo a numero


Saludos amigos, he obtenido de una pagina web cierta información, pero la referente a la fecha se ha copiado en formato de texto así: Dec 31, 2021 y necesito reexpresarla al formato de Excel de fecha corta: 31/12/2021. Hay alguna forma de hacerlo? Gracias de antemano

5 Replies


Go to the desired cell or mark the desired area,

Right mousekey,

Format cells ...

Category: Custom select,

Type: DD.MMMM YYYY for December 21, 2021

or DD / MM / YY for 21/12/21. are ready


Hope I was able to help you with this info.



I know I don't know anything (Socrates)

Thanks. It is not the solution I am looking for. That case works when the cell has a number as the date and you just have to change the format. In my case, the date is a text string and not a number.
best response confirmed by a7024782 (Contributor)



Convert dates stored as text to dates

Follow these steps:

Select a blank cell and verify that its number format is General.

In the blank cell:


Click the cell that contains the text-formatted date that you want to convert.

Enter )


Thank you for your understanding and patience



I know I don't know anything (Socrates)

thanks to you, that was one of my first options, but it doesn't work


Welcome to your Excel discussion space!

With your permission, add more information, in your case this would be helpful, especially for you

... but also for those who would like to help.

Inform us about the Excel version, operating system,

storage medium (hard drive, OneDrive, Sharepoint, etc.), add one or a few photos,

in your case the file (without sensitive data) would be more appropriate,

to look more closely at the causes.

Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5


Thank you for your patience and time.