convert textvalue into date

[Robert1311]

Hello,

I have a small problem. I like to convert a date coming from a database into numbers so that I can use the date in excel.

The date is written as follows in a cell (excelsheet):06-02-2018 (must be text) I can't do anything with this notation in excel.
Hope someone can help me!

Rgds Robert

[63falcondude]

It's not clear, at least not to me, what the contents of the cell are.

Are you saying that it is "06-02-2018", "06-02-2018 (...)", or "(...):06-02-2018 (...)"?

[PaulM100]

You can use: =DATE(RIGHT(A1,4), MID(A1,4,2), LEFT(A1,2)) if the date should remain stored as text in the initial column. Or you can simply record a macro to transform the column in dates with Text to Columns function.

[AlKey]

Try this
where text is in cell A1

Format as Date

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

[Robert1311]

Hi PaulM100, your formula works fine! Thanks very much

Rgds, Robert

[Robert1311]

Hi , thanks for your reply. I was meaning "06-02-2018". But problem is already solved!

Rgs Robert

[Robert1311]

Hi Alkey,

Sorry I was not clear enough, |I should have left out the ":". I was not included in the textvalue! But problem is already solved. Thanks for your effort and time!

Rgds, Robert

[63falcondude]

I was meaning "06-02-2018".

Alternatively, you can highlight the entire column > Data > Text to Columns > Next > Next > Date: DMY (or MDY if the date is June 2nd) > Finish