How to convert text into date format?
 

Referring to the post in General Question

In cell a1, it contains text "2024--01-2007", and I would like to convert
into 24-01-2007 for date format. Through this command,
RIGHT(SUBSTITUTE("2024--01-2007","--","-"),10) is successfully converted to
"24-01-2007", but this text cannot be recognized as a date format. Does
anyone have any suggestion on how to convert this text into date format?
Thank for any suggestion
Eric

How to convert text into date format?
 

How about

=DATE(RIGHT(A1,4),MID(A1,7,2),MID(A1,3,2))

& format as a date

"Eric" wrote:

Referring to the post in General Question

In cell a1, it contains text "2024--01-2007", and I would like to convert
into 24-01-2007 for date format. Through this command,
RIGHT(SUBSTITUTE("2024--01-2007","--","-"),10) is successfully converted to
"24-01-2007", but this text cannot be recognized as a date format. Does
anyone have any suggestion on how to convert this text into date format?
Thank for any suggestion
Eric

How to convert text into date format?
 

Try this formula from the original text ("2024--01-2007")
=DATE(RIGHT(A1,4),MID(A1,7,2),MID(A1,3,2))

Regards,
Stefi

€žEric€� ezt Ã*rta:

Referring to the post in General Question

In cell a1, it contains text "2024--01-2007", and I would like to convert
into 24-01-2007 for date format. Through this command,
RIGHT(SUBSTITUTE("2024--01-2007","--","-"),10) is successfully converted to
"24-01-2007", but this text cannot be recognized as a date format. Does
anyone have any suggestion on how to convert this text into date format?
Thank for any suggestion
Eric

How to convert text into date format?
 

Thank everyone, it works
Eric

"Stefi" wrote:

Try this formula from the original text ("2024--01-2007")
=DATE(RIGHT(A1,4),MID(A1,7,2),MID(A1,3,2))

Regards,
Stefi

€žEric€� ezt Ã*rta:

Referring to the post in General Question

In cell a1, it contains text "2024--01-2007", and I would like to convert
into 24-01-2007 for date format. Through this command,
RIGHT(SUBSTITUTE("2024--01-2007","--","-"),10) is successfully converted to
"24-01-2007", but this text cannot be recognized as a date format. Does
anyone have any suggestion on how to convert this text into date format?
Thank for any suggestion
Eric

How to convert text into date format?
 

You are welcome! Thanks for the feedback!
Stefi

€žEric€� ezt Ã*rta:

Thank everyone, it works
Eric

"Stefi" wrote:

Try this formula from the original text ("2024--01-2007")
=DATE(RIGHT(A1,4),MID(A1,7,2),MID(A1,3,2))

Regards,
Stefi

€žEric€� ezt Ã*rta:

Referring to the post in General Question

In cell a1, it contains text "2024--01-2007", and I would like to convert
into 24-01-2007 for date format. Through this command,
RIGHT(SUBSTITUTE("2024--01-2007","--","-"),10) is successfully converted to
"24-01-2007", but this text cannot be recognized as a date format. Does
anyone have any suggestion on how to convert this text into date format?
Thank for any suggestion
Eric