How to Convert Number Data into Text (Words) in Google Sheets | Google Sheets Tutorials
All right, on this occasion I'm here again with a Google Sheets tutorial video, and this tutorial is about how to convert numeric data into text (words) on a Google Sheets worksheet. As usual, if the steps in the tutorial video aren't clear, then you can follow the description of the steps as follows:
1. Select the "Extensions" menu , select the "Add-ons" menu, select the "Get Add-ons" menu,
2. The "Google Workspace Marketplace" window appears, you type "Numbertext" in the search column feature,
3. Select the "Numbertext" add-on, then click "Install",
4. After the add-on is successfully installed, you type the formula "=NUMBERTEXT(number/ data of the column you want to convert to text)". For example, we will change the number 100 in column "A2", then we can type the formula "=NUMBERTEXT(A2)", and then press "Enter",
5. Done.
You can also change the language of the text by typing the formula "=NUMBERTEXT(number/ data of the column you want to convert to text, "code of the desired language")". For example, if we change text 100 from English to Indonesian, then we can type the formula "=NUMBERTEXT(A2,"id"), and then press "Enter". "id" is the code language for Indonesia, and if you want to change it to another language, then you can find other code languages at the link https://developers.google.com/admin-s... . Hope it is useful.