Results 1 to 3 of 3
  1. #1
    2 Star Lounger AlanWade's Avatar
    Join Date
    Dec 2009
    Location
    Sweden
    Posts
    109
    Thanks
    12
    Thanked 3 Times in 3 Posts

    Date Format Wrong

    I have a simple formula that subtracts one date from another. Although I have formatted the cells to YY-MM-DD unless I enter the date as 2014-05-05 it throws up an error. In the formula bar it changes the date to American format - MM-DD-YYYY.
    Any idea's what is happening.
    I have uploaded a screenshot so you can see what I mean.

    2014-05-07_15-40-34.jpg

    Thanks in advance

    Alan

  2. #2
    2 Star Lounger AlanWade's Avatar
    Join Date
    Dec 2009
    Location
    Sweden
    Posts
    109
    Thanks
    12
    Thanked 3 Times in 3 Posts
    Ok, the problem seemed to be in the date settings on the PC, sorry!

  3. #3
    New Lounger
    Join Date
    May 2014
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Looks like we got the same problem here.

Posting Permissions

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