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".
