try
=DATE(2000+VALUE(RIGHT(A2,2)),VALUE(MID(A2,4,2)),VALUE(LEFT(A2,2)))
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Suman
Sent: Tuesday, October 11, 2011 8:08 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Unable to change date fromate
Hi,
Good evening to all,
Please help in changing date formate.
--
«•´`•.(*•.¸(`•.¸*¸.•´)¸.•*).•´`•»
«´¨*•.¸¸.*.....~*--Suman --*~......*.¸¸.•*¨`»
«•´`•.(¸.•´(¸.• * •.¸)`•.¸).•´`•»
Mob: +91 9810333884
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<<A_html_m691da4f3.gif>>
