Number to Words Converter

Amount in words in Google Sheets

Google Sheets has no built-in function for amounts in words, but a short custom function does it. Open your sheet, choose Extensions → Apps Script, replace the code with the script below, save, and type =AMOUNTINWORDS(A2) in any cell.

The default is the Indian cheque format: 140000 becomes “Rupees One Lakh Forty Thousand Only”. For US style use =AMOUNTINWORDS(A2, "USD"): 1234.56 becomes “One Thousand Two Hundred Thirty-Four Dollars and Fifty-Six Cents”. Paise and cents are rounded to two decimals, and the function also accepts a range such as A2:A20.

Excel has no built-in function for English amounts in words either. This script runs only in Google Sheets; for an Excel file, convert single amounts with the tool above or open the file in Google Sheets.

Copy script

/**
 * Amount in words for Google Sheets (wordcount.com/number-to-words).
 * =AMOUNTINWORDS(A2)         Rupees One Lakh Forty Thousand Only
 * =AMOUNTINWORDS(A2, "USD")  One Thousand Two Hundred Thirty-Four Dollars and Fifty-Six Cents
 * Works on a range too: =AMOUNTINWORDS(A2:A20)
 * @param {number} amount The amount in figures (0 to 999,999,999,999.99).
 * @param {string} style "INR" (default) or "USD".
 * @return The amount in words.
 * @customfunction
 */
function AMOUNTINWORDS(amount, style) {
  if (amount && amount.map) {
    return amount.map(function (row) {
      return row.map(function (v) { return AMOUNTINWORDS(v, style); });
    });
  }
  if (amount === "" || amount === null || amount === undefined) return "";
  var s = String(amount).replace(/[\s,\u20b9$]|Rs\.?/g, "");
  if (/e/i.test(s)) s = Number(s).toFixed(6);
  if (!/^\d*\.?\d*$/.test(s) || !/\d/.test(s)) throw new Error("Not an amount: " + amount);
  var p = s.split("."), whole = parseInt(p[0] || "0", 10), f = ((p[1] || "") + "000").slice(0, 3);
  var cents = parseInt(f.slice(0, 2), 10) + (f.charAt(2) >= "5" ? 1 : 0);
  if (cents === 100) { cents = 0; whole += 1; }
  if (whole > 999999999999) throw new Error("Too large: the maximum is 999,999,999,999");
  var U = ["Zero", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine", "Ten",
    "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Nineteen"];
  var T = ["", "", "Twenty", "Thirty", "Forty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninety"];
  function w100(n) { return n < 20 ? U[n] : T[Math.floor(n / 10)] + (n % 10 ? "-" + U[n % 10] : ""); }
  function w1000(n) {
    var h = Math.floor(n / 100), r = n % 100;
    return (h ? U[h] + " Hundred" + (r ? " " : "") : "") + (r ? w100(r) : "");
  }
  function intl(n) {
    var names = ["", " Thousand", " Million", " Billion"], out = [], i = 0;
    if (n === 0) return "Zero";
    while (n > 0) { if (n % 1000) out.unshift(w1000(n % 1000) + names[i]); n = Math.floor(n / 1000); i++; }
    return out.join(" ");
  }
  function indian(n) {
    if (n === 0) return "Zero";
    var out = [], cr = Math.floor(n / 10000000), lk = Math.floor(n / 100000) % 100,
      th = Math.floor(n / 1000) % 100, r = n % 1000;
    if (cr) out.push((cr >= 1000 ? intl(cr) : w1000(cr)) + " Crore");
    if (lk) out.push(w100(lk) + " Lakh");
    if (th) out.push(w100(th) + " Thousand");
    if (r) out.push(w1000(r));
    return out.join(" ");
  }
  if (String(style || "INR").toUpperCase() === "USD") {
    return intl(whole) + (whole === 1 ? " Dollar" : " Dollars") +
      (cents ? " and " + w100(cents) + (cents === 1 ? " Cent" : " Cents") : "");
  }
  if (whole === 0 && cents) return w100(cents) + (cents === 1 ? " Paisa" : " Paise") + " Only";
  return (whole === 1 ? "Rupee " : "Rupees ") + indian(whole) +
    (cents ? " and " + w100(cents) + (cents === 1 ? " Paisa" : " Paise") : "") + " Only";
}