Thanks Aditya for letting me know but this is not useful when we have 1000s of such occurrences. Could you please suggest about it? Nagi
On Tue, Dec 2, 2008 at 12:23 PM, aDiTyA <[EMAIL PROTECTED]> wrote: > If you have a single column where you want such date format, than select > that column and change format to the format you want. > Regards, > Aditya Mundra > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---