Excel Formulae : How to convert text to date in Excel 2010 (fomat dd/MM/yyyy)

How to  convert a text data cell to date cell in Excel 2010

For Example the format of text file is given below ..... 23/04/2012 12:00:00 AM

17/08/2012 12:00:00 AM

20/10/2012 12:00:00 AM

22/10/2012 12:00:00 AM

29/12/2012 12:00:00 AM

Me Nexus?

For this we have to convert the text to serial number.

the date value function returns the text date to serial number ( calculated as on jan 01 1990)

mid function is use to substring the text

apply the below formula

=DATEVALUE(CONCATENATE(MID(B1,7,4),"/",MID(B1,4,2),"/",MID(B1,1,2)))

after that format the cell as date



Hi Friends,

       Here you can find some Microsoft excel formula that could apply to your excel sheets. Please reply once you tried it out. mail me at  :: belazy1987atgmaildotcom

If you are unable to copy images or any resources from ms document file(.doc/.docx) format try this : java-lazy blog

+joseph james 
+Vipin Cp


Thanks +deepajayaprakash payyanakkal  for her support

Similar posts

1. Taking reports using pivot table in ms office excel
2. How to share an microsoft office excel to work multiple user simultaneously
3. consolidate many table to one using consolidate option in ms office excel
4. Working with pivot table in microsoft office excel 2010
5. working with share point in microsoft office
6. create a internal chat application in organization

http://belazy.blog.com/