NUM2TEXT

Professional Number-to-Text Conversion for Google Sheets™

🇬🇧 English 🇪🇸 Spanish 🇫🇷 French 🇩🇪 German 🇮🇹 Italian 🇵🇹 Portuguese 🇳🇱 Dutch 🇷🇺 Russian 🇯🇵 Japanese 🇨🇳 Chinese 🇹🇷 Turkish

Convertion By Formula:

NUM2TEXT Interface Preview

Convertion By Selection:

NUM2TEXT Interface Preview
NUM2TEXT Interface Preview

Key Features

11

Multi-Language Support

Convert numbers to written text in 11 major languages with native linguistic accuracy and proper grammar rules.

.00

Decimal Precision

Handles decimal numbers with precision up to 3 digits after the decimal point for accurate financial documentation.

2x

Dual Interface Options

Choose between Menu selection conversion for multiple cells or custom formula for individual cell-by-cell conversion.

ƒx

Native Formula Integration

Simple formula syntax that works seamlessly with Google Sheets™' built-in functions and cell references.

⚡

Instant Processing

All conversions happen locally within your spreadsheet with no external API dependencies or delays.

10⁹

Large Number Handling

Supports numbers up to billions with accurate grammatical representation across all supported languages.

Implementation Guide

Installation Steps

  1. Open your Google Sheet™ document
  2. Navigate to Extensions → Add-ons
  3. Search for "NUM2TEXT" Add-on
  4. Click Install
  5. Refresh your Google Sheet™

🌐 View on Google Workspace Marketplace

Or visit directly: https://workspace.google.com/marketplace/app/num2text_multilanguage/972252046731

Method 1: Google Sheets™ Menu

  1. Select the range of cells containing numeric values
  2. Navigate and click to NUM2TEXT → Convert Selection->Language in the menu bar
  3. Numbers will be replaced with their text equivalents in the selected language

Method 2: Custom Formula

Basic Syntax:
=NUM2TEXT(A1, "es")

Converts the numeric value in cell A1 to Spanish text representation.

Decimal Numbers:
=NUM2TEXT(42.567, "fr")

Output: "quarante-deux virgule cinq cent soixante-sept"

Direct Input:
=NUM2TEXT(1234, "de")

Output: "eintausendzweihundertvierunddreißig"

Language Reference

Code Language Example (42)
en English forty two
es Spanish cuarenta y dos
fr French quarante-deux
de German zweiundvierzig
it Italian quarantadue
pt Portuguese quarenta e dois
nl Dutch tweeënveertig
ru Russian сорок два
ja Japanese よんじゅうに
zh Chinese 四十二
tr Turkish kırk iki

Frequently Asked Questions

Does this add-on require an internet connection?
No. All conversions are processed locally within your Google Sheets™ using Google Apps Script. After initial installation, no internet connection is required for the conversion functionality.
What is the maximum supported number range?
The add-on supports numbers up to billions. For example, 1,234,567,890 converts to "one billion two hundred thirty four million five hundred sixty seven thousand eight hundred ninety" in English.
How many decimal places are supported?
The system supports up to 3 decimal places with full precision. Numbers with more than 3 decimal places will be automatically rounded to 3 digits before conversion.
Are negative numbers supported?
Yes. The add-on fully supports negative numbers and applies the appropriate negative prefix according to each language's conventions (e.g., "negative" in English, "menos" in Spanish, "eksi" in Turkish).
Will formulas update automatically when source cells change?
Yes. The NUM2TEXT formula behaves like standard Google Sheets™ functions and automatically recalculates whenever referenced cells are modified.
Can collaborators use this add-on in shared spreadsheets?
Yes. Once installed in a spreadsheet, all collaborators with edit permissions can use the add-on. However, users must install the add-on individually to use it in their own new spreadsheets.
What happens with invalid input?
Non-numeric inputs return "Invalid number" as the error message. When using the Menu method, non-numeric cells remain unchanged during conversion.
Is there a limit on batch conversion size?
There is no hard limit, though very large ranges (thousands of cells) may require several seconds to process. For optimal performance with large datasets, consider converting in smaller batches.
Can conversions be reversed?
Yes. Use Google Sheets™ standard undo function (Ctrl+Z or Cmd+Z) immediately after conversion. We recommend maintaining a backup of original data or working in a copy of your spreadsheet for additional safety.
Why do Japanese and Chinese outputs differ visually?
Japanese uses hiragana phonetic characters (e.g., よんじゅうに for 42) while Chinese uses traditional kanji/hanzi ideographic characters (e.g., 四十二 for 42). This follows proper linguistic conventions for each language system.
Is data transmitted to external servers?
No. All conversions are processed entirely within your Google Sheets™ using Google Apps Script. Your data remains within Google's infrastructure and is never transmitted to external servers or third-party APIs.

Professional Applications

Financial Documentation

Generate written amounts for checks, invoices, and payment documents that require both numeric and text representations.

Compliance Reporting

Create audit-compliant financial reports with numbers spelled out for regulatory requirements and enhanced clarity.

Educational Resources

Develop language learning materials and numeric literacy tools with instant text conversions in multiple languages.

International Business

Generate multilingual invoices, contracts, and business documents for global operations and diverse client bases.

Legal Documentation

Convert monetary amounts to written form as required in legal contracts, agreements, and official documents.

Accounting Standards

Standardize number representations across international accounting documents and multi-currency financial statements.

Technical Support

We're here to assist you

For questions, technical support, or feedback about the NUM2TEXT

Email: numbrate@gmail.com