top of page
LOCALIZATION
Version 2025.01​
Those outside the United States will probably want dates updated to their local date format. This is accomplished with four simple steps:
Change Locale
1. Go to the File menu and click Settings. Choose your "Locale" from the dropdown.
Note: if you don't see the Google Sheets menu bar (File, Edit, View, etc.), it might be hidden. Click the small arrow near the top right of your screen to show the hidden menu bar.
​Next, we need to reset some cells that are already set to the USA date format:
​
Reformat Fiscal Year Date
2. Go to the Settings sheet. Click the cell with the fiscal year start date in it. Click Format > Number > Date
While it may not appear that anything changed (if your fiscal year starts January 1), this will force parts of your reports to display in your newly chosen local format.
Reformat Journal Date Column
3. Go to the Journal. Highlight the entire date column by clicking the column letter:
Change the date format using the same method as above: Format > Number > Date. Now, when entering dates in the Journal, enter them in your local format, and the formatting will be retained rather than converted to the USA format.
Reformat Dates in Report Headers
4. Go to the Translations sheet. Look for the date format mm/dd/yyyy in column B. Change to your preferred date format using the dropdown, or type your own custom date format. This will force dates to display in your local format in report headers.
Want to also change the terminology used throughout the workbook to your native language? Continue on to the next section of the user guide, Translations!
bottom of page