2

Whenever entering the date e.g. day-month-year, it automatically changes to month-day-year. I went into format>number>more formats>more date and time formats, and I changed it to day-month-year. And again, when entering day-month-year e.g. 18-4-2014, it changes it to 4-18-2014, but when I click on the date, it shows as 18/4/2014 next to fx above the page.

So it looks like Google Spreadsheet is messing up. How to fix this?

Improve this question
2
  • 1
    You could put your comment as answer, it fixed my problem, thanks! If you put it as answer, I can mark it as answered.
    – MOTIVECODEX
    Apr 18, 2014 at 21:00
  • 2
    If I enter 18-4-2014 it leaves it as 18-4-2014, but if I enter 5-2-2014, it changes it to 2-5-2014.. But now, the problem is solved by using Netherlands as locale. I am using the new spreadsheet
    – MOTIVECODEX
    Apr 18, 2014 at 21:11

1 Answer 1

Reset to default
2

The solution is to set the correct Local under the Spreadsheet's settings ("This affects formatting defaults, such as currency."). So if you want US.locale style (MM-DD-YYYY), then choose US.Locale. If you are in a different locale and want formatting

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.