Number to Words

@google.dhonbe

11.4K followers · usually 2.1K views a post

Views

35.8K

Likes

737

Comments

11

Shares

294

SoundTikTok sound · original sound - google.dhonbe

Promoted product

Google Sheets

Create online spreadsheets with Google Sheets. Collaborate in real-time from any device and leverage AI to generate formatting, analysis, and more.

8 videos5 creators

Why it worked

The video provides a practical and useful solution to a common problem in spreadsheets, demonstrating a clear value proposition. By showing the step-by-step process of creating and implementing a custom script, it empowers users to enhance their Google Sheets functionality.

Summary

This video demonstrates how to convert numbers into words within Google Sheets by creating and implementing a custom Apps Script. The process involves writing the script, saving it, and then applying the custom function to cells in the spreadsheet to achieve the desired text conversion.

Structure

1Show existing number-to-word conversion in Google Sheets
2Open Apps Script editor and display the code
3Copy and paste the script into a new project

Original caption

#onthisday

More from @google.dhonbe

Product placement

Google Sheets: A spreadsheet application that allows users to create, edit, and share spreadsheets. It ACTS as the interface for the number-to-words conversion script. Removing it would change what happens in the video. Google Apps Script: A scripting platform developed by Google for light application development in the Google Workspace platform. It ACTS as the tool to create the number-to-words conversion function. Removing it would change what happens in the video.

On-screen text

Number to Words Saved to Drive File Edit View Insert Format Data Tools Extensions Help A2 2650.65 2650.65 Loading... Untitled spreadsheet Type "/Dropdown" to insert a dropdown menu Sheet1 Untitled project Files Code.gs Libraries Services Go to Definition Go to References Go to Symbol... Peek Rename Symbol Change All Occurrences Format Document Cut Copy Paste Command Palette function numberToWords(number) { var units = ["", "", "", "", "", "", "", "", "", ""]; var teens = ["", "", "", "", "", "", "", "", "", ""]; var thousands = ["", "", "", ""]; if (number === 0) return ""; function convertHundreds(num) { var result = ""; if (num >= 200 && num < 300) { result += ""; } else if (num >= 100) { result += units[Math.floor(num / 100)] + ""; num = num % 100; } if (num >= 10 && num < 20) { result += teens[num - 10] + ""; } else { result += tens[Math.floor(num / 10)] + ""; result += units[num % 10] + ""; } return result.trim(); } var integerPart = Math.floor(number); var fractionalPart = Math.round(number - integerPart) * 100; var words = ""; var scale = 0; while (integerPart > 0) { var chunk = integerPart % 1000; if (chunk > 0) { words = convertHundreds(chunk) + (scale > 0 ? " " + thousands[scale] : "") + " " + words; } integerPart = Math.floor(integerPart / 1000); scale++; } words = words.trim() + ""; if (fractionalPart > 0) { words += " " + convertHundreds(fractionalPart) + ""; } return words.trim(); } function convertNumberToWords(number) { return numberToWords(number); } Run Debug No functions Execution log Code.gs function myfunction() { }

Transcript

The video demonstrates how to convert numbers to words in Google Sheets using a custom Apps Script. It starts by showing a Google Sheet with numbers entered and their corresponding word conversions. The creator then navigates to the Apps Script editor, where the code for the number-to-words conversion function is displayed. The script is copied and pasted into a new Apps Script project. The file is renamed to 'Number to Words.gs' and saved. Finally, the creator returns to the Google Sheet and uses the custom function '=numbertowords(A2)' to convert a number into words, showing the result in cell B2.

Invoice Generator PRO V2

32.1Kviews@google.dhonbe

9.0

18.6K2155

Invoice Generator PRO V2

18.6Kviews@google.dhonbe