: 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
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
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
@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
, 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
-
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