Re: $$Excel-Macros$$ Date format change by running the macro

... Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: ankur Sent: Tuesday, June 12, 2012 11:22 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date format change by running the macro Thanks Don Sir Very Nice Code But it is not limited to Selected

Re: $$Excel-Macros$$ Date format change by running the macro

With End With End Sub ‘==== Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: ankur Sent: Tuesday, June 12, 2012 5:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date format change by running the macro hi Experts i use this code to solve the q

Re: $$Excel-Macros$$ Date format change by running the macro

Dear Ankur, Please if you don't mind will you make your font sytle and size as a simple Or plain one. It looks too ODD. Thanks for your understanding. Regards, On Tue, Jun 12, 2012 at 11:38 AM, ankur wrote: > *HI ASHISH > **I TRIED THIS CODE FOR YOUR SOLUTION ,BUT IT IS NOT SO GOODbec

Re: $$Excel-Macros$$ Date format change by running the macro

*HI ASHISH **I TRIED THIS CODE FOR YOUR SOLUTION ,BUT IT IS NOT SO GOODbecause i dont know* how to stop the code after the blank cellsExperts will guide me in this issue how to remove this flawfile is attached for your reference * Sub chgDateFormat() ActiveCell.Offset(0, 1).Range("

Re: $$Excel-Macros$$ Date format change by running the macro

Hi Select the range and run this macro Sub kTest() Dim x With Selection x = .Address .Value = Evaluate("if(isnumber(" & x & "),TEXT(" & x & ",""\-00\-00"")+0," & x & ")") .NumberFormat = "dd-mmm-" End With End Sub Kris ExcelFox