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
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?