How to Change Location and Calculation Settings in Google Sheets

The formatting of your data may differ depending the location setting of the Google sheets. Please see below for details to change location and calculation settings:

Step 1: Open a spreadsheet in Google Sheets;

Step 2: Click the File tab from the ribbon, and click the "Spreadsheet settings";

Step 3: In the new window, change the "Locale" and "Time zone";

Step 4: Click the "Calculation" tab to change the calculation settings;

Step 5: Click the "Save settings".