How to Fix Google Sheets Currency Stuck in Pounds

When Google Sheets suddenly displays your financial data in British pounds instead of your local currency, it is almost always due to a mismatch in regional settings. Google Sheets relies on several layers of location data to determine how numbers, dates, and currencies should be displayed by default. If your browser profile, your Google account preferences, or the specific spreadsheet document itself is set to a UK locale, Google Sheets will automatically apply the pound symbol to any cell formatted as currency, even if you are located in North America or Australia. Another common culprit is importing data from an external CSV file, a template created by a UK-based colleague, or a shared link that locked in British formatting rules upon creation. Once a file adopts a specific locale, it retains those rules unless you manually override them. Furthermore, if you copy and paste data from a website or another document that was formatted under UK standards, Google Sheets often inherits those formatting traits. Understanding this multi-layered approach to localization helps you pinpoint exactly where the unwanted pound sign originated, allowing you to apply a targeted fix rather than guessing blindly through your menu options. Many users overlook the fact that shared team templates often carry hidden locale configurations that override personal preferences until explicitly changed by an editor or owner.

When collaborating across international borders, Google Workspace attempts to respect the original creator's environment unless instructed otherwise. If a shared sheet was initiated on a machine configured for British English standards, every collaborator opening that file may see pounds by default. Recognizing this behavior prevents confusion and ensures you know precisely which settings need adjustment to restore your native currency symbols across your entire team's workflow.

The quickest and most effective way to fix the problem for your current file is to update the document's specific locale. This setting overrides your account defaults for that particular spreadsheet, ensuring that currencies match your actual geographic location without requiring you to change your master profile. To change the locale, open your spreadsheet and navigate to the top menu bar. Click on File > Settings. In the dialog window that appears, look for the Locale dropdown menu under the General tab. Click the menu, scroll through the list of countries, and select your correct region, such as the United States, Canada, or Australia. Once you select the correct region, click the blue Save and apply button at the bottom. Your existing currency cells should instantly update to reflect your local currency symbol, transforming those pounds into dollars or your native currency. If your sheet contains formulas that reference other tabs, ensure that those connected sheets also match the new locale to prevent formatting discrepancies across your entire workbook. Failing to update linked spreadsheets can cause data misalignment and confusion when generating collaborative financial reports with your team.

Always verify that your spreadsheet updates successfully after clicking save. In rare instances where complex conditional formatting or custom scripts are active, you may need to refresh your browser tab to force Google Sheets to re-render the visual currency symbols across all active sheets within your workbook.

If you notice that every new spreadsheet you create continues to default to British pounds, changing individual file settings will only act as a temporary band-aid. You need to update your master Google account profile to prevent this recurring issue from plaguing future documents. Google Workspace and standard consumer Google accounts use your primary profile region to establish baseline behaviors for all new documents. To update your master profile, go to your main Google Account management page by clicking your profile picture in the top-right corner of any Google page and selecting Manage your Google Account. Navigate to the Personal info tab on the left sidebar and scroll down until you find the General preferences for the web section. Click on Language and verify whether your region points to the United Kingdom. If it does, edit the setting and change it to your home country. This vital adjustment ensures that all newly created Google Workspace documents adopt the correct regional standards automatically, saving you from repetitive manual fixes every time you open a blank sheet. Keep in mind that enterprise Google Workspace accounts managed by corporate IT administrators may sometimes enforce organizational default locales that require administrator intervention to alter permanently.

Taking the time to adjust your master account settings ensures long-term stability for all future spreadsheet creation. It prevents regional conflicts from recurring every time you spin up a fresh financial model or budget tracker for personal or professional projects.

Sometimes, even after changing your document and account locale, specific cells or columns retain the British pound format due to hardcoded custom number formats. When a cell has a custom format applied directly to it, global locale changes will ignore it, leaving the pound sign locked in place. If this happens, you must manually force the correct currency format onto your data range. Highlight the affected cells containing the incorrect currency symbols. Go to the top menu and select Format > Number. From the expanded dropdown list, choose Currency for standard local formatting, or select Custom currency if you want to pick a specific symbol or remove formatting entirely. You can also use keyboard shortcuts to speed up this workflow. On Windows, press Ctrl + Shift + $ to quickly apply standard currency formatting to highlighted cells. Mac users can achieve the exact same result by pressing Cmd + Shift + $. Always double-check your summary rows and formulas afterward to ensure the underlying values calculate correctly without retaining hidden formatting bugs from previous imports.

Applying manual formatting rules gives you precise control over complex financial sheets where different columns require distinct monetary representations. Mastering these formatting shortcuts ensures your reports always look clean and professional.

If you have successfully updated your file locale and your Google account regional settings, but your Google Sheets currency stubbornly remains in pounds, your web browser might be caching outdated regional data or running an extension that interferes with Google Workspace localization scripts. Browser extensions designed to manage time zones, currency conversions, or regional proxy settings can inadvertently force British formatting onto Google Sheets. Start by opening a fresh Google Sheets document in an Incognito or private browsing window. If the currency displays correctly in private mode, browser extensions or corrupted cache files are definitely causing the glitch. To resolve this, clear your browser cache and cookies specifically for Google domains, and temporarily disable third-party translation or location-spoofing extensions. Restart your browser entirely, log back into your Google account, and your spreadsheets should finally display the correct local currency without further unexpected overrides from cached regional scripts. Ensuring your browser runs clean extensions creates a stable environment for all cloud-based productivity software.

Maintaining a clean browser profile prevents unexpected behavior across all Google Workspace tools, including Docs and Slides. Regular cache maintenance ensures your cloud productivity apps perform efficiently every day.