Asn Murthy
Reputation: 1
How to change format of date and time format in excelwhich is combined
I have a date formate like 12-feb-17 07.54.34.340000000 AM to format 2/2/17 07:54 AM How to convert to this using Excel?
Upvotes: 0
Views: 30
Answers (1)
Scott Craner
Reputation: 152525
the first 2 . need to be :. Use this formula and then format the result as desired:
=--SUBSTITUTE(SUBSTITUTE(A1,".",":"),":",".",3)
Upvotes: 2
Related Questions
- Changing the date format in excel
- How to format date in excel?
- Change the date format in excel
- How to change Date and time format in Excel
- Converting date and time text to date and time format in Excel
- DATE showing in TIME format cell
- How to change date format in Excel
- How to change Date format in excel?
- Excel: date formatting
- How to create and assign a Custom Format of date and time to an entire column in excel worksheet