Re: $$Excel-Macros$$ Date format system using VBA

2013-10-09 Thread xlstime
please share ur vba code with example sheet . Enjoy Team XLS On Thu, Oct 10, 2013 at 6:39 AM, Viswanathan Yoganathan < viswanathan.yoganat...@asia.xchanging.com> wrote: > Hi, > > I am copying the date as text from one sheet and pasting to another sheet > using the co

$$Excel-Macros$$ Date format system using VBA

2013-10-09 Thread Viswanathan Yoganathan
Hi, I am copying the date as text from one sheet and pasting to another sheet using the code activesheet.paste. when i do it so, it is converting to general number 41135. after formatting to d/mm/, the date that is having greater than 12 get converted exactly to d/mm/ where as date tha