Localization

Aspire lets you choose exactly how currency and dates look in your spreadsheet while keeping the add-on UI natural for your browser. The Configuration tab provides three settings:

• Sheet currency format — a sample cell formatted exactly how currency should appear in the spreadsheet
• Sheet date format — a sample cell formatted exactly how dates should appear in the spreadsheet
• Sidebar currency — a dropdown containing your currency code and name, such as USD — US Dollar

This separates two concerns: the sample cells control spreadsheet display formats, while the sidebar combines your selected currency with your browser’s locale.

Configuration reference

Aspire accesses these settings through named ranges, so their physical cells can move in future template versions:

Setting	Named range	What Aspire reads
Sheet currency format	vSheetCurrencyFormat	The cell’s Google Sheets number format
Sheet date format	vSheetDateFormat	The cell’s Google Sheets number format
Sidebar currency	vSidebarCurrency	The leading three-letter code from the selected dropdown item

The v prefix follows Aspire’s convention for a named range containing one value. Do not rename or delete these ranges.

Set your formats

1. Open the Configuration tab.
2. Format the Sheet currency format sample cell using Google Sheets’ normal or custom number-format controls.
3. Format the Sheet date format sample cell the same way.
4. Choose your currency from the Sidebar currency dropdown.
5. Open the Aspire sidebar and go to Settings & Support → Localize.
6. Click Apply Sheet Formats.

The sheet action copies the two sample formats exactly, including the currency symbol, decimal places, grouping, date order, and any custom formatting you add. After changing the sidebar currency, reopen the sidebar so it loads the new selection.

Spreadsheet formatting

Apply Sheet Formats updates these areas:

• Configuration — helper values, monthly amounts, goals, and account balances
• Dashboard — budget, balance, report currency fields, and report dates
• Transactions — the summary values in I3:I5, plus Date, Outflow, and Inflow
• Transfers — transfer helper values, Date, and Amount

Transaction and transfer data-column formats are applied to the full columns from row 8, including empty future rows. New manual entries and imports therefore use the configured formats automatically. The action changes display formats only; it does not read, convert, or rewrite cell values or formulas.

Sidebar formatting

The sidebar uses:

• your Sidebar currency selection for the currency code; and
• your browser’s locale for the symbol position, decimal separator, digit grouping, and date presentation.

For example, two people can select the same currency but see separators and symbol placement appropriate to their own browsers. Reports, previews, and budget values in the sidebar update automatically; you do not need to apply sheet formats for them.

Values stored in the spreadsheet

Aspire writes amounts as numbers and dates as date values. CSV Import, Quick Budget, transactions, and transfers never write formatted strings such as $24.95 or 1.234,56 € into amount cells. Formatting controls how those underlying values look without changing the data used by formulas.

Notes

• Localization is a free feature; no subscription is required.
• The sidebar currency dropdown includes 100 commonly used currencies.
• Applying formats will not repair an existing amount stored as text. Correct the value to a number first, then apply the sheet formats.
• You can change either sample format at any time and run Apply Sheet Formats again.