Spell Numbers: Amount in Words for Invoices
This add-on writes numbers as words in Google Sheets™, with or without the currency, the way each country writes its amounts: “one thousand five hundred dollars and fifty cents”, “Un mil quinientos pesos 50/100 M.N.”, “mil e quinhentos reais e cinquenta centavos”, “eintausendfünfhundert Euro und fünfzig Cent”. Six languages, ten currencies, one permission. Free.
Install it from the Google Workspace Marketplace™, or from Extensions › Add-ons › Get add-ons inside Google Sheets™.
How to use it
- Select the cells with your numbers (one column). The column to the right is where the words go.
- Open the Extensions menu, find Spell Numbers and choose Amount in words, with currency and the currency, or Number to words (no currency). The text appears to the right, row by row, as plain text that everyone can see, also people who do not have the add-on.
- Options in the same menu: UPPER CASE, in parentheses, «un mil» instead of «mil», cents as 50/100 (check style). Language of the words lets you write in a language other than the one of your account. Ctrl+Z (Cmd+Z on Mac) takes it back; with skipped cells it may take more than one press.
The formula
=SPELLNUMBER(A2)writes the number in the language of the spreadsheet.=SPELLNUMBER(A2, "USD")adds the currency;=SPELLNUMBER(A2, "es", "MXN")sets the language and the currency.=SPELLNUMBER(A2:A50)does a whole range in one go.=SPELLNUMBER(A2, "EUR", "upper parens")writes it in capitals between parentheses. Style words: upper, lower, parens, fraction, words, unmil (also in Spanish, Portuguese, French, German and Italian).- Languages: en, es, pt, pt-PT, fr, fr-BE, de, it. Currencies: EUR, USD, GBP, CHF, MXN, COP, ARS, PEN, CLP, BRL.
- Depending on the locale of your spreadsheet, arguments are separated with a comma or a semicolon.
The formula only works for people who have the add-on installed: in a shared file, the others see an error in that cell. For files you share or export, use the menu, which writes plain text.
What it takes care of
- Cells to the right that already have content are left alone and counted in the final message. Cells with text instead of numbers are skipped.
- Each language with its own grammar: veintiún mil, doscientas una libras, un millón de pesos, mil e quinhentos / mil quinhentos e um, dezasseis in Portugal, quatre-vingt-un, septante in Belgium and Switzerland, einhundertein Euro, ventuno, centottanta, millecinquecento.
- Each currency the way its country writes it: Mexican peso “50/100 M.N.” with “Un mil”, Colombian peso “M/Cte”, Peruvian sol “y 50/100 soles”, Argentine peso “con 50/100”, Chilean peso without cents, Brazilian real “reais e centavos”, Swiss franc “Franken und Rappen”, US dollar “dollars and cents” (or “and 50/100 dollars” in check style), pound sterling “pounds and pence”, euro in each language.
- Whole numbers, decimals (“uno coma cinco”, “one point two five”) and negatives, up to 999 billion. Up to 5,000 rows per run.
Languages
The menus and messages follow the language of your Google account: English, Spanish, Portuguese, French, German and Italian. Any other language shows English. The words themselves can be written in any of the six.
Questions
No. The add-on is a script that runs inside your Google account and only asks for permission to edit the spreadsheet it is open in. No servers of ours, no tracking, no account. See the privacy policy.
Because the formula is provided by the add-on, and your colleague does not have it installed. Use the menu for shared files: it writes plain text that everyone sees, and it stays there even if the add-on is removed.
It depends on the locale of your spreadsheet (File › Settings). Spreadsheets that use a decimal comma (Spain, Brazil, France, Germany, Italy, Argentina, Colombia) separate arguments with a semicolon; those that use a decimal point (United States, Mexico, Peru, United Kingdom) use a comma.
Yes. Ctrl+Z (Cmd+Z on Mac) puts the previous values back; if some cells were skipped, it may take more than one press.
No. Google Sheets™ add-ons run in the web version only.
Anything else: support@singletasktools.com.