How to Change (or Convert) Currency in Google Sheets

Navigate to the Google Sheet where you want to change the currency.

In the top-left corner, click on File.

From the dropdown menu, select Settings.

In the Settings window, switch to the General tab.

Change your Locale to the desired country (e.g., United Kingdom for pounds).

Click on Save and reload to apply the changes.

This action changes the default currency for new data entries to the currency of your chosen locale. You can see it in the toolbar.

Click on the rectangle at the top-left corner of your sheet (between the A column and the 1 row) to highlight all cells.

Click on Format in the top menu.

Select Number from the dropdown.

Choose “Custom currency” from the next menu.

In the Custom Currency window, select the desired currency from the list.

Click Apply..

This will change the currency format for all selected cells to the new currency.

Click and drag to select the cells or columns you want to change. You can also hold down the Command (Mac) or Control (Windows) key to select multiple non-adjacent cells.

Go to Format > Number > Custom currency.

Select the desired currency and click Apply.

The currency will change in the selected cells.

Click on the cell you wish to format.

Click Format > Choose Number > Scroll down and select Custom currency.

In the Custom Currency window, you can set how you want the currency to appear. You can include currency symbols, decimal places, and more.

Click Apply to save your changes.

Changing the currency format in Google Sheets is a straightforward process, whether you're updating a single cell or an entire spreadsheet.

By following the steps outlined in this guide, you can efficiently manage and present your data in the currency format that best suits your needs.