none
Excel Formula

    Question

  • We are using Office 2010 here at work. There is a specific Excel document that some people work with. When it is opened by one person, the dates in the cells show in different order than someone else. For instance, in one it shows mm/dd/yyyy and same worksheet shows on someone as dd/mm/yyyy when opened. It might be some quick fix for it, but can't seem to see it. Can anyone help please? Thank you.

    Monday, December 23, 2013 4:12 PM

Answers

  • I found the fix. Somehow the Date format changed in 'Region and Language' for some employees. I changed it back to the desire format. Thank you.

    • Marked as answer by Fash-IT Monday, December 23, 2013 6:30 PM
    Monday, December 23, 2013 6:30 PM