homepage Welcome to WebmasterWorld Guest from 54.167.10.244
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Visit PubCon.com
Home / Forums Index / WebmasterWorld / The Macintosh Webmaster
Forum Library, Charter, Moderators: travelin cat

The Macintosh Webmaster Forum

    
Excel 2008: an old application when it comes to I18N
Want to enter dates as DD/MM?
swa66




msg:3901894
 9:34 pm on Apr 27, 2009 (gmt 0)

I've been using Microsoft Office for my macs for many years and I settled long ago over the fact that the damned thing didn't obey my I18N settings that have dates as DD/MM instead of the American MM/DD.
The settings on my mac were properly set but Excel just never seemed to care.

Got a support call from a few recent converts in the past days over this and they flagged it as important to get fixed for them.

Surfing about I found many pointers that Office 2008 does obey the settings in the international settings under system preferences, but I knew it didn't for date formats while inputting them (output is controlled with the format cells as usual, no problem there).

I was about to complain loudly to Microsoft's mac team, when I did reopen that panel and saw there the text:
This region is incompatible with some older applications. Such applications will use the most recent compatible region.

My bold

Now wait, Excel 2008 was made in 2007 ... not an old application for Leopard at all. It's even aware of Intel CPUs and something I'd been waiting desperately for when it came out to get rid of rosetta.

But yes indeed: switching to UK and then immediately back to Belgium (where I live) does fix the input of dates in Excel 2008 to be DD/MM as dates should be out here.

Now if they only had that bit of info in the FAQ over at Microsoft. Or better yet: if they had not used obsolete APIs to build office on -hey maybe that's the reason why Office is about the only program I know that doesn't play nice with spaces ...

Just trying to increase the odds of somebody finding this faster than I did when I needed it.

 

weeks




msg:3903514
 7:30 pm on Apr 29, 2009 (gmt 0)

Now, THAT is an obscure fix.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / The Macintosh Webmaster
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved