On Sat, Jul 11, 2009 at 1:10 AM, Sunny Agarwal <agarwal.su...@gmail.com>wrote:
> Hi, > Select the entire row again( except text eg; Date is written as text & > this may be conflicting) go to Format--Cells--Customs select the date format > you want.Its done.Even if this doesnt works than simply delete the entire > date row & insert a new row.or else just copy all matter into new sheet & > paste it.Excel will auto recognize the date format > > > > On Fri, Jul 10, 2009 at 5:23 PM, sachinp1...@googlemail.com < > sachinp1...@googlemail.com> wrote: > >> >> Hi, >> >> I'm new one to this group. >> >> I'm facing problem in excel for Date Formating.When I'm selecting >> Entire column of Date, after selecting to Date option in Format, all >> dates are not coming in same format. >> >> Can anybody help me out in this ? >> >> Excel sheet is attached for your reference. >> >> >> Thanks in Advance, >> >> Sachin Patil >> >> >> >> > > > -- > With Regards > SUNNY AGARWAL > -- With Regards SUNNY AGARWAL --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
