Results 1 to 2 of 2

Thread: Display language "long date"

  1. #1
    Junior Member
    Join Date
    Jan 2017
    Posts
    1
    Rep Power
    0

    Display language "long date"

    I am using excel 2013 on a Mac.

    My excel language is set to English.

    When I format a cell to display "long date" it displays the day and month in Czech? I am based in Czech Republic and have installed excel on my Mac here.

    Example: 29/02/2016 is displayed as: pondělí, 29 únor 2016. I have attached the file.Workbook10.xlsx

    Anybody have a solution to set the display date to English?

    Many thanks.

  2. #2
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    13
    in the formattting window, select U.K.


    Language.jpg

Similar Threads

  1. VBA Versions of my "Get Field" and "Get Reverse Field" formulas
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 4
    Last Post: 06-02-2017, 06:15 PM
  2. Capture the "Last Modifed" date from FilePicker
    By jeremiah_j2k in forum Excel Help
    Replies: 6
    Last Post: 09-09-2015, 03:41 PM
  3. Replies: 1
    Last Post: 02-10-2015, 09:41 AM
  4. Replies: 4
    Last Post: 09-09-2013, 05:13 PM
  5. Ordinal Suffix (i.e., "st", "nd", "rd" and "th")
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 0
    Last Post: 03-20-2012, 03:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •