Re: $$Excel-Macros$$ VBA code for pasting date, not plain text

2012-01-05 Thread Paul Schreiner
: Darwin Chan darwin.chankaw...@gmail.com To: excel-macros@googlegroups.com Sent: Thu, January 5, 2012 4:42:57 AM Subject: $$Excel-Macros$$ VBA code for pasting date, not plain text Dear group, I have written a macro for recording data for customer transaction every hour within a day. First I refresh

Re: $$Excel-Macros$$ VBA code for pasting date, not plain text

2012-01-05 Thread dguillett1
You may want to reconsider what you are asking for. One set dd/mm/ and the other mm/dd/ Don Guillett SalesAid Software dguille...@gmail.com From: Darwin Chan Sent: Thursday, January 05, 2012 3:42 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA code for pasting date

Re: $$Excel-Macros$$ VBA code for pasting date, not plain text

2012-01-05 Thread Paul Schreiner
date, not plain text You may want to reconsider what you are asking for. One set dd/mm/ and the other mm/dd/ Don Guillett SalesAid Software dguille...@gmail.com From: Darwin Chan Sent: Thursday, January 05, 2012 3:42 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA

Re: $$Excel-Macros$$ VBA code for pasting date, not plain text

2012-01-05 Thread dguillett1
@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA code for pasting date, not plain text Actually, I almost made the same mistake! What's really happening is that HIS Windows environment is configured to display dates as dd/mm/ so to HIM both date formats look the same. But since OUR environment settings

Re: $$Excel-Macros$$ VBA code for pasting date, not plain text

2012-01-05 Thread Darwin Chan
, January 5, 2012 9:05:16 AM *Subject:* Re: $$Excel-Macros$$ VBA code for pasting date, not plain text You may want to reconsider what you are asking for. One set dd/mm/ and the other mm/dd/ Don Guillett SalesAid Software dguille...@gmail.com *From:* Darwin Chan darwin.chankaw

Re: $$Excel-Macros$$ VBA code for pasting date, not plain text

2012-01-05 Thread Paul Schreiner
- From: Darwin Chan darwin.chankaw...@gmail.com To: excel-macros@googlegroups.com Sent: Thu, January 5, 2012 11:15:42 AM Subject: Re: $$Excel-Macros$$ VBA code for pasting date, not plain text Dear all, I would choose dd/mm