August 29, 2013

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



http://belazy.blog.com/

Facebook comments