Jan 06 2022 10:58 AM
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
Jan 06 2022 11:05 AM
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)
Jan 06 2022 12:06 PM
Jan 06 2022 12:30 PM
Solution
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)
Jan 06 2022 04:41 PM
Jan 08 2022 01:52 AM - edited Jan 08 2022 01:53 AM
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.
Thank you for your patience and time.
Jan 06 2022 12:30 PM
Solution
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)