hi excel experts i have a small problem MY DATE AND TIME FORMAT IS "mm/dd/yyyy hh:mm am/pm" I WANT TO CHANGE COL: A CHANGED IN TO COL:A" ===================================== col:a col:a =====================================
10/11/2010 18:37 11/11/2010 18:37 10/11/2010 18:30 11/11/2010 18:30 10/11/2010 18:40 11/11/2010 18:40 10/11/2010 18:50 11/11/2010 18:50 10/11/2010 18:23 11/11/2010 18:23 10/11/2010 18:10 11/11/2010 18:10 10/11/2010 18:09 ====> 11/11/2010 18:09 10/11/2010 18:07 11/11/2010 18:07 10/11/2010 18:01 11/11/2010 18:01 10/11/2010 17:37 11/11/2010 17:37 10/11/2010 18:33 11/11/2010 18:33 10/11/2010 17:03 11/11/2010 17:03 10/11/2010 21:37 11/11/2010 21:37 10/11/2010 19:37 11/11/2010 19:37 i want change month only thanks in advance -- ---------------------------------------------------------------------------------- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
