Results 1 to 6 of 6

Thread: Date localization in Excel 2008 on leopard

  1. #1
    Join Date
    Apr 2010
    Posts
    98

    Date localization in Excel 2008 on leopard

    Fundamentally when I enter dates in my local format dd/mm/yyyy, choosing Date as the format of the cell causes it to be displayed in US (mm/dd) format. I have comprise my international settings set to UK and this runs in additional apps. Excel seems to pay no attention to the setting. Is it probable to change the defaulting Date format used in Excel. This the entire runs as predictable in Windows.

  2. #2
    Join Date
    Apr 2009
    Posts
    393

    Re: Date localization in Excel 2008 on leopard

    I immediately or presently searched the entire through preferences and might not locate no matter which referring to setting date or time format. I am assuming Office 2008 be supposed to get its date and time from "International Settings" as additional applications do. (Be certain to download and install several updates or service packs from MS if you encompass not previously.) The merely submission I be able to give is to refer you to the MS Office 2008 public determine to give it a couple of days immediately in case the reply pops into my head at the same time as eating breakfast or something then head in excess of to the MS forum.

  3. #3
    Join Date
    Apr 2009
    Posts
    487

    Re: Date localization in Excel 2008 on leopard

    I was told that Mac reads convinced date formats in a different method. I maintain a large membership database for an association and the expiration dates are frequently inaccurate. The system demonstrates expiration in 2008, for illustration, and on my MAC it demonstrates 2013. It has something to do by means of the manner in which dates are entered additional than I cannot for the life of me understand why it has to be this method. It is awful to have comprise to tranquil depend on my system for this database I understand your directions. Additional than, what be able to I do on my end (by means of a Mac) when a system person sends me the membership register. Do I have comprise to tell him to go back and enter each conclusion date (thousands) in a dissimilar format.

  4. #4
    Join Date
    Apr 2009
    Posts
    354

    Re: Date localization in Excel 2008 on leopard

    I necessitate to utilize Visual Basic for Excel, and from what I be able to tell (and what I have comprise and read) Visual Basic is not hold up or maintain for Excel for Mac. Additional than a innovative version or description determine to hold up or maintain it. I have heard of people using applescript as a alternate. Be able to somebody please enlighten me. I would hate to have to utilize Windows immediately to utilize Visual Basic on Excel. Break out your Windows disk then for the reason that MS Office 2008 does not hold up or maintain VB (thanks MS), consequently, no macros. (MS Office 2004 does support VB.) Yes, you be able to utilize Apple script additional than it's not the similar and IMO, does not work well. The next version or description of MS Office (2011) be supposed to be on the market sometime this Fall. MS promises VB is back along by means of some additional pleasant additions.

  5. #5
    Join Date
    Dec 2007
    Posts
    1,727

    Re: Date localization in Excel 2008 on leopard

    If you necessitate it quicker, Office 204 does hold up or maintain VBA, additional than you would have to locate a used copy in view of the fact that it's not sold by MS to any further extent I immediately installed office on Windows working from side to side VMWare Fusion. This is painful. MS is doing their most excellent to force Mac users to utilize Windows for business applications. In addition by means of Office 2004, it uses VB 5 which is the similar as using MS Office 97. The Office 2000/2002/2003 on Windows uses VB 6. So as extended as whatever is completed on the Windows side is compatible by means of Office 97, then it be supposed to run in Mac Office 2004.

  6. #6
    Join Date
    May 2009
    Posts
    857

    Re: Date localization in Excel 2008 on leopard

    MS has promised that they determine to re-establish VB in their next release of Mac Office (whenever that is). For at present, stick by means of Office 2004 for Mac or Office 2007 for Win if you necessitate VB. I do not blame you one bit Dysfunction – I am not purchasing office for Mac until the next iteration comes out that hold up or maintain vba. Luckily sufficient I am able to utilize office '07 at work when I actually necessitate it, and Open Office the rest of the time. At the same time as I do have Office 2007 and utilize it expansively on our Win system, I essentially approximating the look and feel of Office 2008 for the Mac better. It's immediately too bad the "heavy thinkers" at MS determined that Mac users no longer necessitate VB. I in addition agree regarding using Open Office. It's developed into a nice product for the Mac particularly in view of the fact that its last update. Tranquil a bit bloated and sluggish, additional than it's getting there.

Similar Threads

  1. Localization vs Globalization in Asp.net
    By jEEMOOT in forum Software Development
    Replies: 3
    Last Post: 12-01-2011, 05:15 PM
  2. Ms Office 2008 crashes on Snow Leopard
    By Tarjan in forum Windows Software
    Replies: 3
    Last Post: 13-11-2009, 11:04 PM
  3. Mac Os X Snow Leopard release date?
    By Sn0w-Le0p@rD in forum Operating Systems
    Replies: 5
    Last Post: 26-08-2009, 06:07 PM
  4. Date Separator in Excel
    By NIcaBoy in forum Windows Software
    Replies: 2
    Last Post: 25-03-2009, 11:11 AM
  5. My constantly disrupts date from 2008 to 2002
    By PeterT in forum Windows Software
    Replies: 5
    Last Post: 27-10-2008, 02:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,676,652.60506 seconds with 17 queries