{"id":265752,"date":"2021-06-03T17:24:27","date_gmt":"2021-06-03T14:24:27","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-set-the-default-currency-in-google-sheets\/"},"modified":"2021-06-03T17:24:27","modified_gmt":"2021-06-03T14:24:27","slug":"how-to-set-the-default-currency-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-set-the-default-currency-in-google-sheets\/","title":{"rendered":"#How to Set the Default Currency in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a3bf204628d6\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a3bf204628d6\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-set-the-default-currency-in-google-sheets\/#How_to_Set_the_Default_Currency_for_All_Sheets\" >How to Set the Default Currency for All Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-set-the-default-currency-in-google-sheets\/#How_to_Set_the_Default_Currency_for_the_Current_Sheet\" >How to Set the Default Currency for the Current Sheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-set-the-default-currency-in-google-sheets\/#How_to_Check_Whether_the_Correct_Currency_Is_Set_as_the_Default\" >How to Check Whether the Correct Currency Is Set as the Default<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-set-the-default-currency-in-google-sheets\/#How_to_Set_Cells_as_%E2%80%9CCurrency%E2%80%9D_Format_in_Google_Sheets\" >How to Set Cells as \u201cCurrency\u201d Format in Google Sheets<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Set the Default Currency in Google Sheets&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone wp-image-726489 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_hero_1.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Google Sheets Logo on Green Background\" width=\"1200\" height=\"555\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Before creating or editing a spreadsheet in Google Sheets, it\u2019s good to make sure that the default currency for the document matches your expectations. Here\u2019s how to change the default currency and how to check it in existing spreadsheets.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_Set_the_Default_Currency_for_All_Sheets\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"moka_anchor_all_sheets\">How to Set the Default Currency for All Sheets<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To set the default currency for all new Google Sheets, visit your profile language settings at <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/myaccount.google.com\/language\">https:\/\/myaccount.google.com\/language<\/a>. Once you\u2019ve selected your language in the \u201cPreferred Language\u201d section, Sheets will assume that you want to use the currency of your language region as the default in all the new Sheets that you\u2019ll create going forward.<\/p>\n<p>For existing sheets, you\u2019ll need to change the currency manually for each sheet using the method described below.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_Set_the_Default_Currency_for_the_Current_Sheet\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"moka_anchor_single_sheet\">How to Set the Default Currency for the Current Sheet<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Google Sheets remembers the currency setting for each sheet individually. You can change it by setting your current locale. To do so, open your favorite web browser and visit <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/\">Google Sheets<\/a>. Then, load the spreadsheet that you\u2019d like to change the currency for.<\/p>\n<p>Once it\u2019s loaded, click File &gt; Spreadsheet Settings in the menu at the top of the page.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-725772\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/google-sheets-spreadsheet-settings.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Spreadsheet settings under the File menu in Google Sheets\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the \u201cSettings for this spreadsheet\u201d window that pops up, click the \u201cGeneral\u201d tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726310\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-select-general.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the General tab under Settings for this spreadsheet\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Under \u201cLocale,\u201d you\u2019ll see a drop-down menu showing the names of various countries. Pick the country whose currency you want to use. For example, if you want U.S. dollars to be the default currency, select \u201cUnited States.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726311\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-select-united-states.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click United States to set the default currency in Google Sheets\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click \u201cSave Settings\u201d when you\u2019re done.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726312\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-select-save-settings.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Save settings\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>After you change your locale, any money amounts already entered into the sheet will be automatically translated to the currency format of the locale that you selected, and any currency values that you insert after this point will match the locale. This change only applies to this one spreadsheet.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_Check_Whether_the_Correct_Currency_Is_Set_as_the_Default\"><\/span>How to Check Whether the Correct Currency Is Set as the Default<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you\u2019d like to verify that the correct currency is set as the default, click the \u201cFormat\u201d menu and select \u201cNumber.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726314\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-select-number.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Number in the Format menu in Google Sheets\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Locate \u201cCurrency\u201d in the list, and make sure that it shows the correct symbol for the currency that you selected (the dollar symbol (\u201c$\u201d) in the U.S., for example).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726315\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-select-currency.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Currency under Format &gt; Number in Google Sheets\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If it\u2019s correct, then you\u2019re good to go. If not, <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/726309\/how-to-set-the-default-currency-in-google-sheets\/#moka_anchor_single_sheet\">revisit the section above to change your locale.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_Set_Cells_as_%E2%80%9CCurrency%E2%80%9D_Format_in_Google_Sheets\"><\/span>How to Set Cells as \u201cCurrency\u201d Format in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>In Google Sheets, you need to set cells as \u201ccurrency\u201d to see the currency symbol properly. Once it\u2019s set, you can type any number, and Google Sheets will automatically add the currency symbol to those cells. Here\u2019s how to do it.<\/p>\n<p>First, start by selecting the cells where you need to show currency symbols.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726316\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-select-cells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Selecting multiple cells in Google Sheets\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Once you\u2019re done selecting, click Format &gt; Number in the menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726314\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-select-number.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Number in the Format menu in Google Sheets\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the list that appears, select \u201cCurrency.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726315\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-select-currency.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Currency under Format &gt; Number in Google Sheets\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>This will convert all the cells that you selected to \u201cCurrency\u201d format. Type any number in those cells, and Sheets will add the currency symbol for your locale automatically.<\/p>\n<p>Now that you\u2019ve learned the basics, you might also enjoy learning how to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/449986\/how-to-convert-currency-in-google-sheets\/\">convert currency in Google Sheets. Good luck!<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Convert Currency in Google Sheets<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/726309\/how-to-set-the-default-currency-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Set the Default Currency in Google Sheets&#8221; Before creating or editing a spreadsheet in Google Sheets, it\u2019s good to make sure that the default currency for the document matches your expectations. Here\u2019s how to change the default currency and how to check it in existing spreadsheets. How to Set the Default Currency for&#8230;<\/p>\n","protected":false},"author":1,"featured_media":265753,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_hero_1.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-265752","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/265752","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=265752"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/265752\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/265753"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=265752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=265752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=265752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}