On Fri, 11 Nov 2011 13:50:52 +0200, Don <nos...@nospam.com> wrote:
Far more horrible than that -- in an old Excel from around 2000 the user
interface used US settings for reading short dates, if the day of the
month was 12 or less. Otherwise it uses the locale. But it always uses
the locale for displaying them.
So 11/1, 12/1, 13/1 gets changed to 1 Nov, 1 Dec, 13 Jan.
I wrote a macro called "November 9" (9/11) for swapping them back if
they were in the buggy range.
Wow. Reminds me of this:
http://thedailywtf.com/Articles/TransAtlantic-Time-Trap.aspx
--
Best regards,
Vladimir mailto:vladi...@thecybershadow.net