How do I switch from dollars to pounds on Google Finance?

June 28, 2026

To switch from dollars to pounds in Google Finance, open the currency or portfolio view, find the currency settings, and change the display currency to GBP or “British pound sterling.” In Google Sheets, the common workaround is to use a formula like =GOOGLEFINANCE("CURRENCY:USDGBP") to get the exchange rate, then multiply it by your dollar amount.

On Google Finance

Open your portfolio or currency settings.
Look for an option such as “update currency.”
Select GBP and save the change.

In Google Sheets

To convert a value, use the exchange rate formula.
Example: =100*GOOGLEFINANCE("CURRENCY:USDGBP").
If you want the result to look like pounds, format the cell as currency and choose £.

Quick note

Google Finance’s interface can vary a bit depending on whether you’re using the classic view, beta view, or a portfolio page, so the wording of the menu may differ slightly.

TL;DR: change the currency setting to GBP in Google Finance, or use GOOGLEFINANCE("CURRENCY:USDGBP") in Sheets for a live conversion rate.