Every Locale Listed in Google Sheets and a Tool to Save Your Sanity
Hello, Better Sheet members and non-Better Sheet members! This tutorial is about every locale listed in Google Sheets. If you live in a country that is not well represented with blog posts or someone makes a blog post about a Google Sheets issue, they create a Google Sheet formula and then you copy and paste it into your sheet and it has the wrong delimiter. How do you resolve that? I'm going to show you how you can fix that and how you can know if there's a problem. Locales. What are they in Google Sheets?In the sheet, go up to File > Settings. The locale will be there. You'll have settings for this sheet and there’s all these locations that you can choose from. Most of the time, most of the people watching this video are going to have United States. Time zone doesn't really matter for this particular video, but let me just to show you what it probably looks like. For this tutorial, let’s go with Eastern Time – Toronto. Hit “Save and Reload” button. Your sheet should reload. I wrote a little script and it should execute. Once it opens, A1 will show me what the locale code is. That’s what these are in column A. How do you discover your locale code using Google Sheets?If you do want to discover what your locale code is, you can do it two ways: First: Go to File > Settings and just look at what the country is under “Locale.” In our tutorial, it shows “United States.” It should show in the Country column, which is B. Second way: You can use the Apps Script that I created. What this does is every time this sheet opens, it will find the locale, which is: SpreadsheetApp.getActiveSpreadsheet().getSpreadsheetLocale() And then it’ll set that value in A1. Delimiters and errors in Google SheetsSo what happens is when a country is in a certain location, a few things are different. Inside of the formula, the separation between options or items is going to be a either a comma or a semicolon. The default date is going to change, too. It could be month, date , year or date, month, year. It could even be year, month, date. The decimals will be different (period or comma), and also the thousands separators (comma, period, space, and even apostrophe). If you are in a different country that has a different delimiter inside of your formulas and you need to make sure you change those commas to semicolons or vice versa, how do you know which is which? You can go to File > Settings and look at what the country is under “Locale”, like what I showed you before. Or you might just know that’s a different string there with a different delimiter. You might see that error. Getting the correct formulaSo here I created a way for you to change this. Let’s say you want to first check, but you don't want to have to go through this whole list of 72 countries and different languages. What do you do? If you want to check if there is a difference between Argentina and Switzerland, you’ll find out that yes, you need to change something. I will now show you this set of cells that allows you to put in the formula you have (i.e. semicolon) and then you’ll get a new formula. We use the substitute formula to revert all the semicolons to commas or vice versa. Read it all here: https://blog.bettersheets.co/every-locale-listed-in-google-sheets-and-a-tool-to-save-your-sanity-2/ Better Sheets is free today. But if you enjoyed this post, you can tell Better Sheets that their writing is valuable by pledging a future subscription. You won't be charged unless they enable payments. |
Older messages
New Workshop: Spreadsheet Automation 101
Wednesday, February 22, 2023
The next live cohort for Spreadsheet Automation has opened up. Join us! More info → https://maven.com/bettersheets/spreadsheet-automation-101 Join us March 6th → March 9th at 6:00 PM EST / 3:00 PM PST
Make $1,000 from Writing Tweets with 1 Simple Formula
Wednesday, February 22, 2023
I'm gonna show you the one simple formula that got me $1000 from making Twitter templates in a Google sheet. See the templates on sale: http://TwitterTemplates.com Unsubscribe | Update your
Upsides and Downsides of Google Sheets Conditional Formatting
Tuesday, February 21, 2023
Format your data based on certain conditions. Learn how to use Conditional formatting to quickly identify patterns and trends in your data. But there are downsides to Conditional formatting too.
Embed a Number in a Website from a Google Sheet
Monday, February 20, 2023
Learn how to embed a number in a website from.... a google sheet :) -Andrew Google Sheets Wizard at bettersheets.co PS You can now change your Google Sheet avatar! Check it out here: Choose Your
Few hours left for Better Sheets
Monday, February 20, 2023
Wanted to let you know that Better Sheets' price is rising this week on AppSumo You only have a few hours left to get it at $139. Or it'll go up to $149. If you're already a Free Member of
You Might Also Like
Happy "Dead Week?"
Sunday, December 22, 2024
Plus, how to do cross-promotions with newsletters and the 5-second landing page test. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
🧙♂️ [SNEAK PEEK] The chapter worth 100x your investment…
Sunday, December 22, 2024
Plus an update on the “10K Copies Challenge” ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Closes Tonight • Book a Spot in Our "Day after Christmas" Books Newsletter Promo •
Sunday, December 22, 2024
We're emailing a newsletter on the day when many people are shopping with gift cards! enable
Food for Agile Thought #474: Bureaucracies, Proactive Product Quality, Dark Lean, Growing Professional Relationships
Sunday, December 22, 2024
Also: Pure Scrum? Know Your Audience, Master Office Politics, Agile to Agility ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
A new formula for lifestyle creep?
Saturday, December 21, 2024
4% ain't gonna cut it ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
• Authors • Promote your book series on social media • all in one order
Saturday, December 21, 2024
~ Book Series Ads for Authors ~ All in One Order! SEE WHAT AUTHORS ARE SAYING ABOUT CONTENTMO ! BOOK SERIES PROMOTIONS by ContentMo We want to help you get your book series out on front of readers. Our
6 Ways to Celebrate Christmas like a Minimalist
Saturday, December 21, 2024
6 Ways to Celebrate Christmas like a Minimalist I recently read a quote about Christmas that left me thinking. In Letters from Father Christmas, JRR Tolkien says, “Here comes Christmas! That
[Electric Speed] My favorite tools of 2024
Saturday, December 21, 2024
Plus: voice synthesis | smartphone stands ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Closes 12/22 • Book a Spot in Our "Day after Christmas" Books Newsletter Promo •
Friday, December 20, 2024
We're emailing a newsletter on the day when many people are shopping with gift cards! enable
It's Not Too Late to Help People Read
Friday, December 20, 2024
The Now I Know 2024 fundraiser continues