edu.gcfglobal.org Open in urlscan Pro
2606:4700:10::ac43:1c84  Public Scan

Form analysis
2 forms found in the DOM

/en/search/

<form id="smallSearchbar" action="/en/search/" onsubmit="if (!window.__cfRLUnblockHandlers) return false; showSearchSpinner()">
  <span class="form-content-container">
    <input class="topnav-search-field-small home-search-input" pattern=".{1,}" required="" type="text" name="q" placeholder="What can we teach you?" title="Search bar">
    <button class="search-submit-btn-small search-close-btn" type="button" aria-label="close search bar">
      <i onclick="if (!window.__cfRLUnblockHandlers) return false; showSearchBar('close')" class="material-icons close-search-x">close</i>
    </button>
    <button class="search-submit-btn-small" type="submit" aria-label="search button">
      <i onclick="if (!window.__cfRLUnblockHandlers) return false; showSearchBar('close')" class="material-icons">search</i>
    </button>
    <img class="search-submit-spinner left-spinner" src="https://media.gcflearnfree.org/assets/edu-gcfglobal-site/images/transparent-loading-spinner.gif" alt="">
  </span>
</form>

GET /en/search/

<form id="gcfsearch" method="get" action="/en/search/" onsubmit="if (!window.__cfRLUnblockHandlers) return false; showSearchSpinner()">
  <button type="submit" aria-label="search button"><i class="material-icons">search</i></button>
  <div class="mobile-search-input-wrapper">
    <input id="request" class="searchinput" pattern=".{1,}" required="" type="text" name="q" size="21" maxlength="120" placeholder="What can we teach you?" autocomplete="off" title="Search bar">
  </div>
</form>

Text Content

close search
search menu

Topics

close
 * I want to...
   * Get started with computers
   * Learn Microsoft Office
   * Apply for a job
   * Improve my work skills
   * Design nice-looking docs
   * More...
 * Microsoft Office
   * Word
   * Excel
   * PowerPoint
   * Access
   * More...
 * Computers
   * Getting Started
   * Smartphones & Tablets
   * Typing Tutorial
   * Windows
   * Online Learning
   * More...
 * The Internet
   * Basic Internet Skills
   * Online Safety
   * Social Media
   * Zoom Basics
   * Email
   * More...
 * Google
   * Gmail
   * Google Docs
   * Google Sheets
   * More...
 * The Job Search
   * Career Planning
   * Resume Writing
   * Cover Letters
   * Job Search and Networking
   * Business Communication
   * Entrepreneurship 101
   * Careers without College
   * Job Hunt for Today
   * More...
 * Skills for Today
   * 3D Printing
   * Freelancing 101
   * Personal Finance
   * Sharing Economy
   * Decision-Making
   * More...
 * Creativity & Design
   * Graphic Design
   * Creativity
   * Photography
   * Image Editing
   * Photoshop
   * Learning WordPress
   * More...
 * Core Skills
   * Math
   * Reading
   * Science
   * Grammar
   * Language Learning
   * Critical Thinking
   * More...

 * For Educators
 * Translations
 * Staff Picks
 * All Topics

print
English expand_more expand_less
 * English expand_more expand_less
 * Español
 * Português

LoginJoin for free!


EXCEL TIPS -


UNDERSTANDING REGIONAL DIFFERENCES IN EXCEL

Back to Tutorial
EXCEL TIPS
UNDERSTANDING REGIONAL DIFFERENCES IN EXCEL

search
person_outline arrow_drop_down
menu
All Topics My Account About Us FAQ Contact Us
EN ES PT
Signin Signup Dashboard Profile Logout
navigate_before Tutorial
search



EXCEL TIPS: UNDERSTANDING REGIONAL DIFFERENCES IN EXCEL

560d88f6369ca18833b60c1d 578e38098d7fad05000e7a11

LESSON 27: UNDERSTANDING REGIONAL DIFFERENCES IN EXCEL

/en/excel-tips/how-to-add-line-breaks-in-excel/content/


UNDERSTANDING REGIONAL DIFFERENCES IN EXCEL

Millions of people use Microsoft Excel to organize and calculate data. And
because Excel is popular around the world, it's available in many different
languages and versions. However, there are also many regional differences when
it comes to certain tasks in Excel, including separating arguments, writing
numbers, and function names.

For example, we use the U.S. English version of Excel in our Microsoft Office
tutorials, so you may notice that some things work slightly differently in your
version. Let's take a look at some of the most important things that can vary if
you're using Excel in another language or version.

SEPARATING ARGUMENTS IN FORMULAS

In many versions of Excel—including the U.S. English version—arguments in a
formula are separated by a comma, as in the example below:

=VLOOKUP("Photo frame", A2:B16, 2, FALSE)

But in many countries, arguments must instead be separated by a semicolon, like
this:

=VLOOKUP("Photo frame"; A2:B16; 2; FALSE)

WRITING NUMBERS AND DATES

There are many ways to write out various numbers and dates, and their format
will vary depending on your region. For example, in the United States, decimal
numbers are written with a period, as in the example below:

3.25

But in many countries, decimal numbers are written with a comma, like this:

3,25

There is a similar type of variation with numbers that use the thousandths
place. In the U.S., this is typically written with a comma, like this:

1,000

In other countries, it's often written like this:

1.000

You'll typically need to use the standard formatting in your country when
entering values like this in Excel. The same is true for calendar dates. For
example, dates in the U.S. are usually written as month/day/year. For example,
May 25, 2016 would be written like this:

5/25/16

But in most countries, it will typically be written as day/month/year, like
this:

25/5/16

FUNCTION NAMES

Excel has hundreds of functions to perform different types of calculations.
However, the exact name of any function will depend on your computer's language
settings. For example, the SUM function is written as SOMME in French, SUMME in
German, and SUMA in Spanish. Check out some of the resources below to learn more
about language-specific function names:

 * Microsoft Excel Function Translations
 * Easily Insert an English Formula in Your Non-English Excel Version (Note that
   this will require you to install a third-party plug-in for Excel.)
 * Function Names Changed in Non-English Versions of Excel


ADJUSTING REGIONAL SETTINGS

TO VIEW AND MODIFY LANGUAGE SETTINGS:

To view or modify your language settings within Excel, go to File > Options >
Language. From there, you can see what language you're currently using, add a
new language, and more.




TO VIEW AND MODIFY DATE AND NUMBER SETTINGS:

Unlike function names—which are determined by the language settings within
Excel—your date and number settings are controlled by the operating system.
Let's take a look at how to view and modify these settings in Windows.

 1. Open the Control Panel (usually found in the Start menu).
    
 2. Locate and select Change date, time, or number formats within the Clock,
    Language, and Region category.
    
 3. The Region dialog box will appear. Click Additional settings.
    
 4. The Customize Format dialog box will appear. From here, you can view and
    modify your preferred settings for decimal symbols, list separators, digit
    grouping, dates, and more.
    

Continue

Previous: How to Add Line Breaks in Excel
Next:Excel Tips Quiz


/en/excel-tips/excel-tips-quiz/content/


keyboard_arrow_up keyboard_arrow_down

ABOUT US

Who We Are
Meet the Staff
Work With Us
Who Uses Us + Our Partners


EDUCATORS' RESOURCES

Teacher Guides
Resources and Tools


HELP AND SUPPORT

FAQ
Terms of Service
Privacy Notice
Cookie Policy
Contact Us
My Account