+ Reply to Thread
Results 1 to 6 of 6

Date issue in Excel for Mac

  1. #1
    Registered User
    Join Date
    12-17-2014
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    29

    Angry Date issue in Excel for Mac

    Screen Shot 2017-10-05 at 15.05.17.png

    I have the following issue, all my settings seem to be fine (Europe) and my time settings are fine as well, only in Excel it shows in US format. Any idea on how I can change this?

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Date issue in Excel for Mac

    From the screenshot it looks like it's an US-english implementation of Excel or maybe some add-in which uses US-english.
    Did you check the language settings in File->Options->Language?
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Registered User
    Join Date
    12-17-2014
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    29

    Re: Date issue in Excel for Mac

    Hi Tsjallie,

    I have a Mac which does not have file->options>language? This also just happened over night? It was never a problem, I think it has to do with an update of Excel....

  4. #4
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Date issue in Excel for Mac

    Hmm, didn't having ended up in the Mac-section of the forum
    Googled around a bit and it seems that a lot of (non-english) mac-user have this problem.
    One would expect to find an option to set the language in Excel (in case of a Mac that should be somewhere in de Preferences of the Excel menu), but apparently it isn't.
    May be this post can help you: https://answers.microsoft.com/en-us/...6-eb2425f3ca40

  5. #5
    Registered User
    Join Date
    12-17-2014
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    29

    Re: Date issue in Excel for Mac

    Thanks for the help, unfortunately neither options fixed it. Language settings on my mac are everywhere on English(UK), also in Excel. Installed the app you suggested, also did not fix it...

  6. #6
    Registered User
    Join Date
    12-17-2014
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    29

    Re: Date issue in Excel for Mac

    I fixed it! This is the solution:

    Go to System Preferences -> Languages and Region
    Select the preferred language and select Region. Here you should select your local region. For me it stated English (UK), but when I changed this to Netherlands-Dutch, after a reboot of the Mac it was fixed!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Date issue in excel
    By N1k100 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-06-2014, 06:32 PM
  2. Excel Date issue!!
    By clarbare2 in forum Excel General
    Replies: 3
    Last Post: 03-23-2014, 10:44 AM
  3. Excel Date Format issue
    By Plutark in forum Excel General
    Replies: 3
    Last Post: 06-07-2012, 11:09 AM
  4. [SOLVED] Date Issue (Excel VBA)
    By lloydgodin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-17-2012, 04:47 PM
  5. Excel 2008 : Excel Date Format Issue
    By XcelPanda in forum Excel General
    Replies: 5
    Last Post: 10-31-2011, 06:32 AM
  6. Excel 2007 : Excel Date/Year issue
    By clippysdead in forum Excel General
    Replies: 3
    Last Post: 08-24-2011, 02:46 PM
  7. Excel Date Formatt Issue
    By donnyp02 in forum Excel General
    Replies: 1
    Last Post: 04-25-2008, 10:43 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1