On 2011-11-11 12:50, Don 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.
Haha that's just insane. -- /Jacob Carlborg