Forum Discussion
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
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
I know I don't know anything (Socrates)
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.
OK...you 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.
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
I know I don't know anything (Socrates)
