Forum Discussion
Convertir fecha en cadena de testoo a numero
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)
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)
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)
- 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 attachMaximum size: 71 MB • Maximum attachments allowed: 5Thank you for your patience and time.