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 code activesheet.paste. when i do it so, it is converting to > general number 41135. > > after formatting to d/mm/yyyy, the date that is having greater than 12 > get converted exactly to d/mm/yyyy where as date that is having less than > 12 for which the month and date get interchanged. > > example: there are 3 lines having date 19/07/2013, 22/07/2013, > 3/10/2013. The first two dates results exactly as same where as the > 3/10/2013 get converted to 10/03/2013. Please help me on this what could be > wrong, > > Thanks, > Vishwa. > > > > "CONFIDENTIALITY NOTICE: This message and any attachment are > confidential and may also be privileged. If you are not the intended > recipient of this e-mail you may not copy, forward, disclose or otherwise > use it or any part of it in any form whatsoever. If you are not the > intended recipient please telephone or e-mail the sender and delete this > message and any attachment from your system." > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
