We're nominated again this year for Best Microsoft Excel Add-in at the Global Excel Awards! ❤️🌟
If ASAP Utilities has helped you in Excel, you can support it with a quick vote→. It only takes about 30 seconds.
Find us in the second category: Best Microsoft Excel Add-in. You can skip other categories if you're unsure about them.
logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Wednesday April 8th, 2026

Tip of the Day | Wednesday April 8th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Insert US English Formula and Convert to Local Format...

This tool lets you enter a formula using US English notation. This type of formula is often referred to as an international Excel formula because it's the format used in most tutorials, videos, websites, and forums.
It automatically converts your formula and inserts it into your selected cells using your local Excel language and regional settings.
A pop-up input box will appear where you can type or paste a formula using:
  • English function names such as SUMIF, DATE, or RANDBETWEEN
  • A comma (,) as the list separator
  • A point (.) as the decimal separator
    ASAP Utilities translates the formula into the correct format for your Excel version, so you no longer need to manually adjust function names, separators, or decimal characters.
    For example, if you're using a non-English version of Excel and enter the formula "=SUMIF(A1:A5,">5")*1.2", it will be automatically converted based on your Excel language and settings.
    Examples of localized conversions of =SUMIF(A1:A5,">5")*1.2:
  • German (Deutsch): =SUMMEWENN(A1:A5;">5")*1,2
  • Spanish (Español): =SUMAR.SI(A1:A5;">5")*1,2
  • French (Français): =SOMME.SI(A1:A5;">5")*1,2
  • Italian (Italiano): =SOMMA.SE(A1:A5;">5")*1,2
  • Dutch (Nederlands): =SOM.ALS(A1:A5;">5")*1,2
  • Portuguese (Português do Brasil): =SOMA.SE(A1:A5;">5")*1,2
    You can also choose to insert the formula as an array formula.
    This tool is especially helpful when copying formulas from websites, tutorials, videos, or books that use the US English format, without worrying about compatibility with your version of Excel.

    Screenshots

    Example screenshot: Easily paste English formulas into your local Excel version
    Easily paste English formulas into your local Excel version

    Starting this tool


    Formulas  ›  Insert US English Formula and Convert to Local Format...

    Choose your language preference below

    English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

    Trustpilot
    Download  


    • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.