You may need to set the spreadsheet's locale as well to match what you want (File-Spreadsheet settings) - this also sets the format of numbers to have commas for decimals if you are in Europe for example.