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.com>wrote:
> 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 :
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
