With Google Sheets, you can easily change the currency format for your cells. This is helpful if you’re working with international clients or customers. In just a few clicks, you can have your cells display the currency symbol of your choice

How to change currency in Google Sheets

This is a step by step guide for the query - How to change currency in Google Sheets. Follow the steps given below to achieve the desired result.

Step 1 :

select the cells that you want to format.

How to change currency in Google Sheets - Step - 1

Step 2 :

To format the cells as currency, click “Format” from the top menu.

How to change currency in Google Sheets - Step - 2

Step 3 :

Select “Number” from the drop-down menu.

How to change currency in Google Sheets - Step - 3

Step 4 :

you can choose the default currency or rounded currency format.

How to change currency in Google Sheets - Step - 4

Step 5 :

To create a custom currency go to 'Custom currency' option.

How to change currency in Google Sheets - Step - 5

Step 6 :

In the next window, you can select your desired currency symbol. Once you’ve made your selections, click “Apply.” Your cells will now be formatted as currency.

How to change currency in Google Sheets - Step - 6

Conclusion :

As you can see, it’s easy to change the currency format for your cells in Google Sheets. This can be helpful when working with international clients or customers. With just a few clicks, you can have your cells display the currency symbol of your choice.