How to Get Your Own Country’s Currency Format in Google Doc Spreadsheet
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.
About Article Author
This is an another awesome Google Doc Spreadsheet tutorial from Info Inspired team. Refer our growing dedicated Google Doc Spreadsheet
Earlier we have learned how to create a Line Graph or Line Chart using Google Doc Spreadsheet. In this Google
Hope you are a regular reader of our Google Doc Spreadsheet tutorials. We already have some rich content there to
Duplicate contens can be appeared on your data due to typo graphical errors, careless entry or while applying copy and
When you have a long range of data arranged in row wise and want to change it into column wise,
Every systematic job will be based on a meticulous job schedule. But to achieve the goal, the schedule is not enough.