Re: $$Excel-Macros$$ Need help to convert date formate
Hi Vinod, Thank you very much, Vinod can you give me vba code for that issue Regards Vilas On Sat, Aug 28, 2010 at 9:11 PM, VILAS CHAVAN vilaschav...@gmail.com wrote: Hi vinod, You are not sending me any attachment please send solve attachment please regards Vilas On Sat, Aug 28, 2010 at 12:26 PM, Vinod N nvino...@gmail.com wrote: Hi Vilas, Please select column A and use Text-to-Columns under Data menu... Next choose the desired date format from Format-- Cells option.. Solved copy of your sample file attached... Thanks Vinod N On Sat, Aug 28, 2010 at 7:20 PM, VILAS CHAVAN vilaschav...@gmail.com wrote: Hi friends, Need help this is data is automatically updating in this excel and i want to always convert this date in date formate please help Aug 27, 2010 this date need to convert in 27-Aug-2010 Please help -- With Best Regards, Vilas Chavan Email : cvi...@ymail.com, vilaschav...@gmail.com Mumbai - Maharashtra -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks and Regards Vinod N http://cavinod.blogspot.com/ -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- With Best Regards, Vilas Chavan Email : cvi...@ymail.com, vilaschav...@gmail.com Mumbai - Maharashtra 9967458882 -- With Best Regards, Vilas Chavan Email : cvi...@ymail.com, vilaschav...@gmail.com Mumbai - Maharashtra 9967458882 -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Need help to convert date formate
Hi Vilas, Please find below the macro recorded by me... Sub Date_Format() ' ' Date_Format Macro ' Macro to convert date format- 8/29/2010 by Vinod ' Columns(A:A).Select With Selection Selection.TextToColumns Destination:=Range(A1), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _ Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _ :=Array(1, 1), TrailingMinusNumbers:=True Selection.NumberFormat = [$-409]d-mmm-yy;@ .ColumnWidth = 10 .HorizontalAlignment = xlCenter .VerticalAlignment = xlBottom .WrapText = False .Orientation = 0 .AddIndent = False .IndentLevel = 0 .ShrinkToFit = False .ReadingOrder = xlContext .MergeCells = False End With Range(A1).Select End Sub On Sun, Aug 29, 2010 at 11:40 AM, VILAS CHAVAN vilaschav...@gmail.comwrote: Hi Vinod, Thank you very much, Vinod can you give me vba code for that issue Regards Vilas On Sat, Aug 28, 2010 at 9:11 PM, VILAS CHAVAN vilaschav...@gmail.com wrote: Hi vinod, You are not sending me any attachment please send solve attachment please regards Vilas On Sat, Aug 28, 2010 at 12:26 PM, Vinod N nvino...@gmail.com wrote: Hi Vilas, Please select column A and use Text-to-Columns under Data menu... Next choose the desired date format from Format-- Cells option.. Solved copy of your sample file attached... Thanks Vinod N On Sat, Aug 28, 2010 at 7:20 PM, VILAS CHAVAN vilaschav...@gmail.com wrote: Hi friends, Need help this is data is automatically updating in this excel and i want to always convert this date in date formate please help Aug 27, 2010 this date need to convert in 27-Aug-2010 Please help -- With Best Regards, Vilas Chavan Email : cvi...@ymail.com, vilaschav...@gmail.com Mumbai - Maharashtra -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks and Regards Vinod N http://cavinod.blogspot.com/ -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- With Best Regards, Vilas Chavan Email : cvi...@ymail.com, vilaschav...@gmail.com Mumbai - Maharashtra 9967458882 -- With Best Regards, Vilas Chavan Email : cvi...@ymail.com, vilaschav...@gmail.com Mumbai - Maharashtra 9967458882 -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks and Regards Vinod N http://cavinod.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :
Re: $$Excel-Macros$$ Need help to convert date formate
Oops Missed to attach the file... Now done... On Sun, Aug 29, 2010 at 12:56 AM, Vinod N nvino...@gmail.com wrote: Hi Vilas, Please select column A and use Text-to-Columns under Data menu... Next choose the desired date format from Format-- Cells option.. Solved copy of your sample file attached... Thanks Vinod N On Sat, Aug 28, 2010 at 7:20 PM, VILAS CHAVAN vilaschav...@gmail.comwrote: Hi friends, Need help this is data is automatically updating in this excel and i want to always convert this date in date formate please help Aug 27, 2010 this date need to convert in 27-Aug-2010 Please help -- With Best Regards, Vilas Chavan Email : cvi...@ymail.com, vilaschav...@gmail.com Mumbai - Maharashtra -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks and Regards Vinod N http://cavinod.blogspot.com/ -- Thanks and Regards Vinod N http://cavinod.blogspot.com/ -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe dateformateissue_Solved_VInod.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Need help to convert date formate
Hi vinod, You are not sending me any attachment please send solve attachment please regards Vilas On Sat, Aug 28, 2010 at 12:26 PM, Vinod N nvino...@gmail.com wrote: Hi Vilas, Please select column A and use Text-to-Columns under Data menu... Next choose the desired date format from Format-- Cells option.. Solved copy of your sample file attached... Thanks Vinod N On Sat, Aug 28, 2010 at 7:20 PM, VILAS CHAVAN vilaschav...@gmail.com wrote: Hi friends, Need help this is data is automatically updating in this excel and i want to always convert this date in date formate please help Aug 27, 2010 this date need to convert in 27-Aug-2010 Please help -- With Best Regards, Vilas Chavan Email : cvi...@ymail.com, vilaschav...@gmail.com Mumbai - Maharashtra -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks and Regards Vinod N http://cavinod.blogspot.com/ -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- With Best Regards, Vilas Chavan Email : cvi...@ymail.com, vilaschav...@gmail.com Mumbai - Maharashtra 9967458882 -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe