$$Excel-Macros$$ Re: How to change Date format in to number
=VALUE(TEXT(A2,MMDD)) On May 29, 9:05 am, Prabhu prabhugate...@gmail.com wrote: Hi Friends, I have change my cell which in the date format ex.MMDD or DDMM 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 Book1.xls 35KViewDownload -- -- 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
$$Excel-Macros$$ Re: How to change Date format
Use this in E2 and drag down =DATE(2000+RIGHT(B2,2),LEFT(RIGHT(B2,4),2),LEFT(B2,LEN(B2)-4)) On May 12, 5:14 pm, Prabhu prabhugate...@gmail.com wrote: Hi friends, Plz help to change date format when downloaded report from 1st of every month to 9th of the month will be like DMMYY . I have no issue in changing the format using text to column from 10th date because it will be in DDMMYY. I have attached the sample sheet for your reference.Plz help to know the date format as DDMMYY for entire month.(i am requesting macros to do the same) Regards, Prabhu bsninvreport xls.xls 39KViewDownload -- -- 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
Re: $$Excel-Macros$$ Re: How to change Date format
another variant =DATE(20RIGHT(B2,2),MID(TEXT(B2,00),3,2),LEFT(TEXT(B2,00),2)) On Thu, May 12, 2011 at 8:58 PM, GoldenLance samde...@gmail.com wrote: Use this in E2 and drag down =DATE(2000+RIGHT(B2,2),LEFT(RIGHT(B2,4),2),LEFT(B2,LEN(B2)-4)) On May 12, 5:14 pm, Prabhu prabhugate...@gmail.com wrote: Hi friends, Plz help to change date format when downloaded report from 1st of every month to 9th of the month will be like DMMYY . I have no issue in changing the format using text to column from 10th date because it will be in DDMMYY. I have attached the sample sheet for your reference.Plz help to know the date format as DDMMYY for entire month.(i am requesting macros to do the same) 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