Hi Prabhu, just convert those dates into below format using below formula.
lets say in col A17 thr is date thn in col B17 type this formula. =TEXT(A17,"yyyymmdd") A B 5/29/2011 20110529 > >From: Prabhu <prabhugate...@gmail.com> >To: excel-macros@googlegroups.com >Sent: Sun, 29 May, 2011 9:35:23 AM >Subject: $$Excel-Macros$$ How to change Date format in to number > >Hi Friends, > > >I have change my cell which in the date format ex.YYYYMMDD or DDMMYYYY to >original number i.e smiler to >type date.I have attached the sheet in which Column A shows date format and >Column B is what i need to convert A in to B as a number. > > >Plz help. > > >Regards > > >Prabhu -- >---------------------------------------------------------------------------------- > >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
