How to adjust the date and currency format in Google Sheets

Along with Excel, the current Google Sheets is also an office tool that many people choose to use, because you can use it online, all operations are automatically saved and the interface is not too different from Excel. And in the process of working with Google Sheets, we will encounter a different function name, date format, and default currency format. If so, users can change the Local and Timezone settings in Google Sheets.

1. How to convert Excel file to Google Sheets
2. How to set up the right to edit spreadsheets on Google Sheets
3. How to convert the currency of each column, row in Google Sheet

How to change the digital format on Google Sheets

Step 1:

At the spreadsheet on Google Sheets, we click on the File (File) menu and select Spreadsheets settings .).

How to adjust the date and currency format in Google Sheets Picture 1

Step 2:

If the user wants to use the function in English, use the Vietnamese format date, the currency unit is VND, then edit in this interface.

At the General (General) setting, the Local section we select Vietnam, the Time zone is (GMT + 7: 00) Bangkok and then press the Save button (Save Settings).

How to adjust the date and currency format in Google Sheets Picture 2

Now when you click on the Format Management section and then click on the Number field, you will see the currency and date format converted to the correct format in Vietnam.

How to adjust the date and currency format in Google Sheets Picture 3

Also, when you click on another format (More Formats), there will be additional formatting options if you need it.

How to adjust the date and currency format in Google Sheets Picture 4

They can change the format you want to use and click Apply to change.

How to adjust the date and currency format in Google Sheets Picture 5

So we changed the format on Google Sheets to change the format of functions, dates, and currencies. The format in the lesson will be in Vietnamese format.

See more:

1. How to convert the currency of each column, row in Google Sheet
2. How to enter 0 in Google Sheets
3. 6 useful functions in Google Sheets you may not know yet

I wish you all success!