Convert Number into Foreign Words using Google Sheets - Excel Tips and Tricks - video Dailymotion

RabiGurungXybernetics

Discover discover how to convert number into words using Google sheet. Or translate number a different language.  This video we will be answering question these questions. How do I convert numbers to text in Google Sheets? Or how do I convert numbers in Google Sheets? How to convert number to words in Indian rupees in Google Sheets? How do I automatically translate cells in Google Sheets?   Practically, how to convert amount to words in google sheets, or google convert number to words.  We will be using the numbertext function. We will show you how to number in google sheets. We will use google sheet to convert number to words. Or answer to how do I convert numbers to letters in sheets?   Google Sheets provides powerful functions that can be used to convert numbers into English words. Two functions that are particularly useful for this purpose are numbertext and moneytext. The numbertext function converts a number into its English equivalent, while the moneytext function converts a number into its English equivalent as a currency value. To use these functions, simply enter the number you want to convert into a cell, and then use the function alongside that cell. For example, to convert the number 1234 into its English equivalent, you would enter "=numbertext(1234)" into a cell, and the result would be "One Thousand Two Hundred and Thirty-Four". Similarly, to convert the number 1234 into its English equivalent as a currency value, you would enter "=moneytext(1234)" into a cell, and the result would be "One Thousand Two Hundred and Thirty-Four Dollars". These functions can be a useful tool for businesses, accountants, and anyone who needs to work with numbers in a clear and concise way.   Install NumberText Add-On  1) Extension ~ Add-ons ~ Get add-ons  2) Search for "Numbertext"  3) Click on Numbertext  4) Install  5) Continue  6) Select your GMail account  7) Allow  8) Done  9) Close the popup   US Dollars  =MONEYTEXT(A2,"USD")   Indian Rupee  =MONEYTEXT(A3,"INR")   Canadian dollars  =MONEYTEXT(A4,"CAD")   Currency In Chinese Characters  =MONEYTEXT(A5,"CNY","zh")   Add "Only"  =MONEYTEXT(A6,"GBP") & " only"   Replace Nationality Text  =SUBSTITUTE(MONEYTEXT(A7,"CAD"),"Canadian ","")    Language Codes  https://developers.google.com/admin-sdk/directory/v1/languages   https://www.google.com/search?q=convert+chinese+to+english&rlz=1C1VDKB_enCA951CA952&oq=convert+chinese+to+&aqs=chrome.0.0i512j69i57j0i512l4j0i20i263i512j0i512l3.5184j1j7&sourceid=chrome&ie=UTF-8    how to convert amount to words in google sheets,google convert number to words,how to convert number to words in excel,numbertext function in excel,  How do I convert numbers to text in Google Sheets?,How do I convert numbers in Google Sheets?,How to convert number to words in Indian rupees in Google Sheets?,How do I automatically translate cells in Google Sheets?,  google

Transcript

00:00Converting a numeric number into a word can be very handy especially when you're

00:04writing a check. There is an add-on on Google Sheet that you can use to do that

00:08conversion. Go to extension, add-ons, get add-ons. In here you're going to be

00:13looking for a text called number text like this and hit enter and this is the

00:19one that you can install. Click on it, install and continue. You're gonna have

00:24to associate your Google account to this app here. Go ahead and associate it.

00:29Allow. Click on done and close this. Now you have access to a function called

00:37money tax so it's a equal money tax and the first argument would be the numeric

00:43value cell here this one a2 comma followed by the country currency code.

00:48Let's say if you're on US dollar you go USD and close parenthesis. If you want

00:55Indian rupee you can do the same thing and copy the formula here and convert

00:59or rather change this USD into INR like that. Likewise you can use the same

01:07formula. I'm gonna copy the cell and do it same thing for Canadian which is CAD. The

01:16country code or the currency for the country code can be found on this web

01:19page here. I'll leave the link on the description below so check it out. So that

01:24is to convert numbers into a text format. So let's say for example if you want to

01:29convert that this into a foreign language let's say for example I'm going to use

01:33money tax. I'm going to convert this number here into Chinese Yuan which is a

01:39CNY and then I can convert it into a different language. This is going to be

01:44Mandarin and close parenthesis and hit enter. It will convert this numeric value

01:49into a Chinese code here. So the Chinese code can be found on the link here. I'll

01:53provide the link in the description as well with all the different language

01:57code today that's available. So next thing I want to do is I want to show you

02:00you know some of the checks require the word only at the back here. This is how I do it.

02:05I'm gonna use a Great Britain pound let's say money tax and I'm going to convert

02:11this into Great Britain pound like I said so GB pound and then all you have to do

02:18is you have to concatenate the word space only like this. Make sure you put a

02:23space here so that this it looks nicer. Let me show you what I mean by that. So

02:27it will show you all this and the word only is displayed here at the last end

02:31here and also sometimes we don't need this like US Canadian or Indian the word in

02:38this here. The way to do it would be to use the word substitute equals substitute

02:44is a standard substitute we don't need the add-on for this one here and then of

02:49course you're gonna use the word or function called money tax and you're

02:53gonna convert this into let's say Canadian dollar right and close

02:59parenthesis comma and substitute takes the second argument as what you want to

03:04look for so I'm gonna look for the word Canadian don't forget to put it

03:08a space here because you're gonna have to get rid of everything leaving this space

03:11alone and then I'm gonna replace that particular text with blank and close

03:16parenthesis and hit enter you can see it's written as a number without the

03:21nationality in it

Convert Number into Foreign Words using Google Sheets - Excel Tips and Tricks

Category

Transcript

Recommended