-
From: Darwin Chan
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/ format first, however
--------
>
>
> ------------------
> *From:* dguillett1
> *To:* excel-macros@googlegroups.com
> *Sent:* Thu, January 5, 2012 9:05:16 AM
> *Subject:* Re: $$Excel-Macros$$ VBA code for pasting date, not plain text
>
> You
@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 set
the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Thu, January 5, 2012 9:05:16 AM
Subject: Re: $$Excel-Macros$$ VBA code fo
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,
I think the problem is that your first Pivot table (at A4)
doesn't contain "Dates", it contains a string of characters that RESEMBLE a
date.
If you try to change the date format to... say... Long Date... nothing happens.
After you copy the table to cells, when you copy this string DOWN,
Excel lo
