BTurkeli
Reputation: 93
Convert text formatted date DD.MM.YYY HH.MM to standart DD.MM.YYYY date format in Excel
I have a very troublesome date format that I need to convert to standart short date as DD.MM.YYYY. I have tried some formulas as below but I cannot reach the true output. Any help will be appreciated...
Upvotes: 0
Views: 93
Answers (1)
Scott Craner
Reputation: 152505
Use this:
=DATE(MID(A1,7,4),MID(A1,4,2),LEFT(A1,2))
Then format it as DD.MM.YYYY
Upvotes: 1
Related Questions
- Convert text YYYY-MM-DD HH:MM:SS to Excel date
- How to convert text dates into date format like mm/dd/yyyy in Excel
- Change Date Format in Excel from mm-dd-yy hh:mm to dd-mm-yy hh:mm
- Excel Convert DateTime stored as Text, YYYYMMDDhhmmss, to formatted date and time "mm/dd/yy hh:mm"
- Converting MM:DD:YYYY hh:mm:ss to DD:MM:YYYY hh:mm:ss in excel
- Convert date from d/M/yy hh:mm tt To dd/MM/yyyy HH:mm
- Convert date as text "YYYY:DD:MM hh:mm:ss" to real date
- Need to convert a specific text format to date format MM/DD/YYYY
- How to convert text to date format in Excel
- convert text to dd/mm/yyyy format