HomeApplicationOffice information

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!

3.8 ★ | 10 Vote
change Google Sheets format

You should read it

May be interested

  • How to create a phone number can be called on Google SheetsHow to create a phone number can be called on Google Sheets
    google sheets has a call feature when entering phone numbers into data tables, via callers installed on the computer.
  • How to view editing history on Google SheetsHow to view editing history on Google Sheets
    google sheets will automatically save the content edits on the file so that users can review it when needed, or restore the modified version.
  • 6 useful functions in Google Sheets you may not know yet6 useful functions in Google Sheets you may not know yet
    in this article, i will show you 6 useful functions for the google sheets spreadsheet that you should know such as vlookup, countif, sumif, join, index, ... in addition, you can refer to the functions. and other tips follow the link in the post.
  • How to fix Google Sheets not allowing scrollingHow to fix Google Sheets not allowing scrolling
    google sheets is a free and easy to use spreadsheet application that works right out of the box. however, sometimes users face some glitches.
  • How to count words on Google SheetsHow to count words on Google Sheets
    on google sheets, to count the number of words in each cell, users can use the formula with the counta function.
  • How to set up the right to edit spreadsheets on Google SheetsHow to set up the right to edit spreadsheets on Google Sheets
    when working on google sheets online, if you want to restrict editing of certain column or row data areas, you can set editing rights on google sheets.
  • How to insert current time into Google SheetsHow to insert current time into Google Sheets
    instead of manually entering the current time into google sheets, you can use the now and today functions to do the job. these functions will insert and display the current date and time, and automatically update the value when the google sheets spreadsheet changes.
  • How to format conditional cells in Google SheetsHow to format conditional cells in Google Sheets
    on google sheets features conditional formatting conditional formatting cells. with this feature you can enter data with different values.
  • How to Open CSV FilesHow to Open CSV Files
    csv (comma-separated value: comma-separated values) are files that contain data from tables listed in plain text, such as email contact information. although csv files can be opened in many programs (such as editors), the data within this format will be most fully displayed in spreadsheet software, such as microsoft excel, openoffice calc or google sheets (google sheets). you will need to select 'open' from the 'file' menu, select the csv file and adjust the delimiter settings if the data is not displaying properly. the same steps can be applied on google sheets, but this requires you to upload the file to google servers. the work process will run more smoothly if you arrange data neatly and scientifically!
  • How to write notes, comments on Google SheetsHow to write notes, comments on Google Sheets
    on google sheets has a comment writing feature, notes in the data box can help users understand the content while working online with many people.

Office information