SOLVED

Convertir fecha en cadena de testoo a numero

Occasional Contributor

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

@a7024782 

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.

OK...you are ready

 

Hope I was able to help you with this info.

 

NikolinoDE

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 (Occasional Contributor)
Solution

@a7024782 

 

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:

Enter =DATEVALUE(

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

Enter )

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

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

@a7024782 

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.

 

NikolinoDE