To set a spreadsheet's locale and time zone in Google Sheets, open the file on a computer, click File > Settings, choose from the Locale and Time zone menus under General, and click Save settings. The change applies to the whole file for everyone and sets its default currency, date and number formats. In a 12-tab ProfitDrawer bookkeeping spreadsheet, amounts use the currency symbol typed on the Settings tab, so check both after importing the file.
Steps (computer):
- Open the spreadsheet in Google Sheets.
- Click File > Settings.
- Under General, open the Locale menu and pick your country.
- Open the Time zone menu and pick your time zone.
- Click Save settings.
What the locale changes: the file's default currency, date and number formatting, including which character is the decimal separator. For example, a locale can switch dates between month first and day first.
What it does not change: your language in Google Sheets. That is set in your Google Account settings. If your account uses a language other than English, you can show function names in that language by unticking Always use English function names in the same settings box; Sheets supports functions in English and 21 other languages.
Calculation: the Calculation tab sets the calculation mode: Automatic, or Manual, which recalculates only when you click Calculate.
The settings belong to the file, not to each viewer: everyone working on it sees the same locale and time zone, wherever they are.
ProfitDrawer's setup guide notes that if Google shows a different currency after import, you set your symbol on the Settings tab.
Source: Set a spreadsheet's location and calculation settings: Google Docs Editors Help · Updated
Tools and spreadsheets for this
Related questions
- How do I change the currency format in Google Sheets?
- Can I use my own currency in a ProfitDrawer spreadsheet?
- How do I change the date format in Google Sheets?
- How do I open an Excel file in Google Sheets?
- Do ProfitDrawer spreadsheets work in Google Sheets and Excel?
- How do I make a copy of a Google Sheets file into my own Drive?
All questions on ProfitDrawer Answers →
General information, not tax, legal or financial advice. Check the rules for your state and your situation.

