A spreadsheet can cross a border without its numbers changing, yet still invite the wrong reading. Does 04/05/2026 mean April 5 or May 4? Is 1,250 a thousand-plus amount or a decimal value? The recipient needs a declared convention before entering new data.
This guide prepares a Google Sheets spreadsheet in a desktop browser for a recipient using another locale. It covers a continuing shared sheet or a separate handoff copy. It does not require changing either person’s computer settings.
Agree what the next person will type
Ask which country’s conventions the recipient expects, which currency the figures represent, and which time zone governs deadlines. Those are separate decisions. A German recipient might need comma decimals while reviewing amounts that remain in US dollars.
Write a short note at the top of a spare worksheet. For a hypothetical handoff, it could read: “Locale: Germany. Amounts: USD, two displayed decimal places. Dates: year-month-day. Order identifiers: text. Deadlines: Europe/Berlin.” Use the actual agreed zone and currency for your work.
Decide whether everyone will continue editing the same spreadsheet. Google’s settings documentation confirms that locale changes apply to the whole file and are visible to all collaborators. A recipient’s location does not give them a separate view of its regional defaults.
If the current team must retain its convention, prepare a separate copy through File > Make a copy. Name it with its destination and purpose, such as Orders — Germany handoff. If copying or editing is unavailable, ask the owner to prepare it. Mark which file will receive future updates so that two copies do not silently become competing originals.
Keep evidence before changing defaults
Record the original locale and time zone, one known date in words, an amount including its currency, and a total. Preserve an untouched copy if permissions allow. Include an identifier with leading zeros, if the sheet has one. Compare these same records after preparation.
A useful baseline says “May 4, 2026; 1250.50 USD; identifier 00427,” rather than repeating an ambiguous date string. Check that meaning against the source record. If nobody can establish whether an existing date means April 5 or May 4, stop and resolve it with the sender. Regional settings cannot supply missing evidence.
Change the file’s locale once
- In the working copy, open File > Settings. Under General, note the existing Locale and Time zone.
- Set Locale to the agreed country. For the hypothetical German handoff, choose Germany. Change Time zone only if the team has agreed to change its time basis.
- Choose Save settings. Reopen Settings afterward to confirm the choices persisted. Compare your baseline records before entering new data.
The locale establishes default number, date and currency formatting; it does not translate your Sheets menus. Function language is separate too. If the Always use English function names option is available, retain English for the formulas below. Otherwise use the corresponding function name offered by Sheets.
Do not change a deadline’s zone merely because the recipient lives elsewhere. A cell displaying 09:00 is incomplete scheduling information. Google’s date-value documentation explains that date/time serial values do not store a time-zone offset. Write the intended zone in the header or handoff note, and arrange any necessary conversion explicitly.
Make dates and currency unmistakable
For actual date cells, select the range and choose Format > Number > Custom date and time. Arrange a four-digit year, two-digit month and two-digit day separated by hyphens; choose Apply. A known May 4 date should read 2026-05-04. Widen the column if the complete value is obscured.
For amounts, select the range and use Format > Number > Custom currency. Search for the currency the amounts already represent, choose the required decimal display, and apply it. Label the column Amount (USD) or the appropriate currency code, even if the cells also show a symbol. Google documents both paths in its formatting guide.
Choosing another currency format changes presentation; it does not perform an exchange-rate calculation. If 1250.50 USD becomes a euro-labelled amount without a conversion, correct the currency label. The German locale and a USD column can coexist.
Inspect existing custom formats separately: do not assume that changing defaults rewrites every column appropriately. Formatting also cannot turn an incorrectly interpreted April date into the intended May date. Verify the calendar meaning, not simply the arrangement of digits.
Run a three-cell rehearsal
Use spare cells in the handoff copy for this hypothetical Germany-locale check. Have the recipient repeat the entry check before adding real records. These are expected outcomes derived from the example, not results of a live account test.
| Test | Action | Expected meaning |
|---|---|---|
| Decimal entry | In B2, type 1250,50 without a thousands separator. In C2, enter =B2*2. | C2 represents 2501, which may display as 2501,00 or with grouping. It must not represent 250100. |
| Stored date | Put the verified May 4 date in A2. Check =DAY(A2) and =MONTH(A2) in spare cells. | Day is 4; month is 5. A year-first display alone is insufficient evidence. |
| Identifier | Before typing, format D2 with Format > Number > Plain text, then enter 00427. | The identifier retains all five characters. Compare it with the source. |
The formula examples use one argument or simple multiplication, avoiding a multi-argument formula’s separator issue. Do not use a copied complex formula as the first test of whether a decimal entry works.
If arithmetic fails, inspect the entry and formula bar. Check =ISNUMBER(B2); FALSE means the amount is not stored as a number. Clear that rehearsal cell, apply Number formatting, then re-enter the agreed comma-decimal value. For real records, return to the source instead of replacing punctuation across the whole sheet. Commas may belong to text or grouping.
If the date checks return day 5 and month 4, preserve the suspect value and recover its intended date from the baseline or source. Reformatting it again only disguises the same mistake. Likewise, changing 427 to text cannot establish that its missing prefix was 00.
Finish at the recipient’s first edit
Send the agreed working link with the convention note and one known date-and-amount pair. Ask the recipient to confirm that pair and enter the rehearsal amount. Remove temporary checks only after both sides agree; retain the note beside the data.
If a downloaded file is required, use File > Download and choose the requested format, as described in Google’s file-copy documentation. Repeat the checks in the recipient’s actual application. This guide’s Sheets settings are not a compatibility guarantee for another spreadsheet program.
If preparation goes wrong, restore the recorded settings in the working copy or restart from the untouched original. Restoring a locale does not reverse incorrectly entered data. Recover those cells from preserved records, then repeat the rehearsal before accepting further edits.
Sources, versions & scope
The steps describe the documented controls and expected checks; they are not a claim that every device or software release has been physically tested. Platform and version differences are stated with the procedure.
