I am a power user of Microsoft Excel. That gives me much freedom in using the cloud powered Google Doc Spreadsheet. We can find lots of similarity between Google Doc Spreadsheet and Microsoft Excel. Mainly in formatting and formulas. But Google Doc spreadsheet has some distinct features by its own. Here is one such Google Spreadsheet feature that power users may like to use. This is about changing the currency format in Google Doc Spreadsheet to users own country currency format.
How to Apply a Currency Format in Google Doc Spreadsheet
Select the cell that containing numbers where you want to apply a currency format.
Then got Format menu and select Numbers.
There you can see currency formats. Click on it to apply the format.
Most probably you will find your country’s currency format there. If you could not find your country’s currency format on Google Doc Spreadsheet, just go to Format->Numbers->More Currencies. If you can find your country’s currency format there, just apply it. Else we can see how to get your country’s currency format in Google Doc Spreadsheet. The below step is also applicable to change existing currency format in Google Doc Spreadsheet.
How to Change the Currency format in Google Doc Spreadsheet
Here I’m changing the Google Spreadsheet currency format to Rs. (Indian Currency).
To change the currency format in Google Doc Spreadsheet to Rs., follow the below steps.
Go to File->Spreadsheet Settings.
Choose your country under “Locale” and under “Time Zone” your countries time zone. For example I’ve selected India under “Locale” and “GMT +5:30” under “Time Zone”. Then Save Settings.
That’s all. Now you can apply your country’s currency format to any number on Google Doc Spreadsheet.
If you liked this post follow our other Google Doc Spreadsheet tutorials.
What to Do When Currency Format that You Want Not Available in Google Sheets
There is another workaround to get worlds any currency format in to your Google Sheet. You can format your number with custom text. That means you can suffix or prefix currency text to number and that also keeps or retain the number format.
See the detailed tutorial here.