How To Change The Currency In Google Sheets (Updated 2026)

In this video, we discuss how to change the currency in Google Sheets to easily format numbers as currency for your financial data formatting. Applying a custom currency format and managing global currency symbols is vital for any reliable accounting spreadsheet. Dive into this Google Sheets tutorial to optimize your budget tracker formatting and business finance tools. #GoogleSheets #FinancialFormatting #BusinessTools 00:00 Intro 00:01 Purpose of changing currency in Google Sheets 00:14 Clarification on exchange rates vs display 00:26 Starting at Google.com 00:31 Accessing Google Apps menu 00:39 Selecting Google Sheets 00:44 Google Sheets dashboard 00:46 Opening the target spreadsheet 00:49 Spreadsheet interface overview 00:53 Highlighting data for formatting 01:06 Importance of pre-selection 01:15 Navigating to the Format menu 01:19 Accessing Number options 01:24 Selecting Custom currency 01:29 Custom currencies window overview 01:32 Searching for specific currencies 01:44 Adjusting currency display settings 01:52 Handling decimal places and cents 01:58 Formatting negative values 02:06 Applying the new currency format 02:10 Verifying the updated spreadsheet data 02:16 Troubleshooting and readjusting settings 02:22 Tip: Formatting vs underlying values 02:30 Tip: Cleaning text and symbols from cells 02:37 Tip: Applying format to columns or whole sheets 02:46 Conclusion and final results