Convert Numbers to Words in Google Sheets: Formula

If you use Google Sheets for creating invoices, salary slips, purchase orders, or sales orders, you may want to convert numbers to words. This may be to comply with regulations or to make the numbers easier to read. Whatever the reason, I have written a formula and a custom-named function for it.

Before proceeding, please note that my formula is coded to convert numbers up to 8 digits long, meaning from 1 to 99,999,999.00

There are four ways to convert numbers to words in Google Sheets:

Using a formula.
Using a custom-named function.
Using the BAHTTEXT native function.
Using a supported add-on or Google Apps Script.

In this post, I will provide my custom-coded formula and a named function based on it that you can import into your Sheet and use. The output will be in an international system.

If you want to use an add-on, you can find one in the Google Workspace Marketplace. You can go to the Marketplace from the Extensions menu in your Sheet.

The BAHTTEXT function is already featured in my function guide. This native Google Sheets function converts a number into Thai text. You can translate it into English and use it to some extent, but it has limitations that I already mentioned in that tutorial.

Formula to Convert Numbers to Words in Google Sheets

To convert numbers to words in Google Sheets, you can use the following formula:

=INDEX(TRIM(LET(n,INT(B7),vrA,SEQUENCE(9),vrB,SEQUENCE(10,1,10),vrC,SEQUENCE(8,1,20,10),vrD,VSTACK("One","Two","Three","Four","Five","Six","Seven","Eight","Nine"),vrE,VSTACK("Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"),vrF,VSTACK("Twenty","Thirty","Forty","Fifty","Sixty","Seventy","Eighty","Ninety"),td," Thousand ",hd," Hundred ",mn," Million ",ln,VALUE(LEFT(n,2)),fv,RIGHT(n,5),le,LEN(fv),ltdn,XLOOKUP(SEQUENCE(5),IF(le=1,"",le),VALUE(RIGHT(fv,2)),),rgA,VSTACK(VALUE(MID(fv,SEQUENCE(5),1)),VALUE(MID(LEFT(TEXT(n,"00000000"),3),SEQUENCE(3,1,3,-1),1))),rgB,XLOOKUP(rgA,vrA,vrD,IF(,,)),rgC,XLOOKUP(ltdn,vrB,vrE,IF(,,)),rgD,XLOOKUP(IF(ltdn-rgA>0,ltdn-rgA,),vrC,vrF,IF(,,)),z,INDEX(rgA,1),w,INDEX(rgA,2),ww,INDEX(rgA,3),uu,INDEX(rgA,6),u,INDEX(rgA,7),a,INDEX(rgB,1),aa,INDEX(rgB,2),aaa,INDEX(rgB,3),aaaa,INDEX(rgB,4),aaaaa,INDEX(rgB,5),aaaaaa,INDEX(rgB,6),pq,INDEX(rgB,7),b,INDEX(rgC,2),bb,INDEX(rgC,3),bbb,INDEX(rgC,4),bbbb,INDEX(rgC,5),c,INDEX(rgD,2),cc,INDEX(rgD,3),ccc,INDEX(rgD,4),cccc,INDEX(rgD,5),xl,XLOOKUP(VALUE(LEFT(fv,2)),vrB,vrE,0),xll,XLOOKUP(IF(VALUE(LEFT(fv,2))-INDEX(rgA,2)>0,VALUE(LEFT(fv,2))-INDEX(rgA,2),""),vrC,vrF,IF(,,)),codeAA,IFS(AND(le=5,xl>0,ww=0),xl&td&" "&aaa,AND(le=5,xl=0,ww=0),xll&" "&aa&td&" "&aaa,AND(le=5,xl>0,ww>0),xl&td&" "&aaa&hd,AND(le=5,xl=0,ww>0),xll&" "&aa&td&" "&aaa&hd,1=1," "),testA,XLOOKUP(ln,vrB,vrE,IF(,,)),testB,XLOOKUP(IF(ln-u>0,ln-u,),vrC,vrF,IF(,,)),codeA,IFS(AND(testA>0,uu>0),testA&mn,AND(testB>0,uu>0),testB&" "&pq&mn,AND(testA>0,uu=0),testA&mn,AND(testB>0,uu=0),testB&" "&pq&mn,1=1," "),codeB,IFS(AND(le=5,bbbb>0),bbbb,AND(le=5,bbbb=0),cccc&" "&aaaaa,1=1," "),codeC,IFS(AND(n>999999,z=0,w=0,ww=0,uu=0)," ",AND(n>999999,z=0,w=0,ww>0,uu=0),REPLACE(codeAA,1,10,""),1=1,codeAA),IFS(le=1,a,AND(b>0,le=2),b,AND(b=0,le=2),c&" "&aa,AND(le=3,bb=0),a&hd&cc&" "&aaa,AND(le=3,bb>0),a&hd&bb,AND(le=4,bbb>0,w=0),a&td&aa&bbb,AND(le=4,bbb=0,w=0),a&td&aa&ccc&" "&aaaa,AND(le=4,bbb>0,w>0),a&td&aa&hd&bbb,AND(le=4,bbb=0,w>0),a&td&aa&hd&ccc&" "&aaaa,AND(n>9999,n<100000),codeC&" "&codeB,AND(n>99999,n<1000000),aaaaaa&hd&" "&codeC&" "&codeB,AND(n>999999,n<10000000,uu>0),pq&mn&aaaaaa&hd&" "&codeC&" "&codeB,AND(n>999999,n<10000000,uu=0),pq&mn&" "&codeC&" "&codeB,AND(n>9999999,n<100000000,uu>0),codeA&" "&aaaaaa&hd&" "&codeC&" "&codeB,AND(n>9999999,n<100000000,uu=0),codeA&" "&codeC&" "&codeB))))

The above formula converts the number in cell B7 into words in the international system. When you use the formula, just replace B7 with the cell reference containing the number.

Screenshot of a Google Sheets formula to convert numbers to words. — Figure 1

Note: The cell reference only appears once in the formula, making it very convenient to use.

The number-to-words converter formula has the following features:

It is a combination formula and does not require any helper cells.
It converts the numbers from 1 to 99,999,999.
When the cell containing the number contains decimals, it converts the integer part only. The decimal part is ignored. You can use the ROUND, ROUNDDOWN, or ROUNDUP functions to round the number before converting it to words. For example, you can replace B7 with ROUND(B7).

Named Function to Convert Numbers to Words in Google Sheets

If you prefer a much cleaner way to convert numbers to words in the international system in Google Sheets, you can use my custom-named function, NumberToWords().

Syntax of the NumberToWords custom-named function:

NUMBERTOWORDS(number)

This carries all the features of the above number-to-word converter formula.

Here are some examples of how to use NumberToWords in Google Sheets:

=NUMBERTOWORDS(125055) // Returns "One Hundred Twenty Five Thousand Fifty Five"
=NUMBERTOWORDS(A1) // Converts the number in cell A1 to words
=NUMBERTOWORDS(ROUND(A1)) // Rounds and converts the number in cell A1 to words

Custom Google Sheets named function to convert numbers to words. — Figure 2

To use the NumberToWords function, you need to import it into the sheet you want to use. If you want to use it in multiple sheets, you can import it into each sheet or make a copy of the first sheet.

Follow these three steps to import NumberToWords and convert numbers to words in your Google Sheets:

Make a copy of my sample sheet.
Open the sheet in which you want to use the function.
Go to the Data menu > Named functions and click Import function.

NumberToWords Array Formula

We usually use the ARRAYFORMULA function in Google Sheets to expand a formula result, but it does not work with the NumberToWords custom-named function.

However, you can still convert multiple numbers to words in one go using NumberToWords and the MAP lambda function.

Here is the generic formula:

=MAP(array,LAMBDA(r, NUMBERTOWORDS(r)))

Replace array with the cell range that contains the numbers. For example, to convert the numbers in the range C3:C7 to words, you can use the following formula in cell D3, assuming that D3:D7 is empty:

=MAP(A1:A10,LAMBDA(r, NUMBERTOWORDS(r)))

Array formula in Google Sheets to convert numbers to words for multiple cells at once. — Figure 3

Conclusion

You can use the UPPER, LOWER, and PROPER functions with the above number verbalizer function to format the converted numbers to words in Google Sheets.

You can also prefix or suffix custom text, such as “Rupees” or “Only”.

Here are a few examples:

=UPPER(NUMBERTOWORDS(1502)) // Returns ONE THOUSAND FIVE HUNDRED TWO
=NUMBERTOWORDS(1502)&" Only" // Returns One Thousand Five Hundred Two Only
="Rupees "&NUMBERTOWORDS(1502)&" Only" // Returns Rupees One Thousand Five Hundred Two Only

53 COMMENTS

Alvin November 1, 2022 At 12:16 pm

Thanks a lot..

your formula is awesome..

Vijeta August 16, 2019 At 10:01 am

Hi,

We want to use it in Sheets to convert number/amount to words with Rupees and Paise. Please help.

- Prashanth August 16, 2019 At 10:18 am
  
  Hi, Vijeta,
  
  Sorry for the inconvenience. The formula is very complex and it would take me lots of time and also ‘painful’ to re-code it. I’ll definitely make an attempt in future.
  
  Thanks for your understanding.
  
Arun.s June 19, 2019 At 5:59 pm

Hi Prashanth,

Could you please provide me the access?

- Prashanth June 20, 2019 At 10:45 am
  
  Hi, Arun,
  
  I have included the link within the post! Still, I am sending the same via email. Please check your inbox!
  
Prachi Bhansali June 10, 2019 At 7:40 pm

How about decimal numbers?

Jessie Recto April 21, 2019 At 1:29 pm

Hi Prashanth,

Thank you so much of this amazing formula. How about if there is a centavo amount and I need to show it as well in words, can you share it with me the formula?

Cheers,

Jessie

Fadli February 20, 2019 At 11:28 am

How to adopt to different language?

- Prashanth February 20, 2019 At 1:48 pm
  
  Hi, Fadli,
  
  What about using the GOOGLETRANSLATE function.
  
  You can wrap the formula that returns the amount in words with GOOGLETRANSLATE function. Here is one example.
  
  =googletranslate(if(and(F7="Upper",F9=TRUE),Upper(C14),if(and(F7="Proper",F9=TRUE),proper(C14),if(and(F7="Lower",F9=TRUE),lower(C14)," "))),"en","es")
  
  Best,
  
Viji February 11, 2019 At 3:46 pm

Please send me the files.

- Prashanth February 11, 2019 At 5:02 pm
  
  Please check your inbox.
  
AADI October 18, 2018 At 2:50 pm

HI,

CAN I HAVE THE ACCESS PLEASE

- Prashanth October 18, 2018 At 3:26 pm
  
  Hi, Aadi,
  
  I have included the number to word converter download link at the last part of the post. Please check that.
  
  Thanks.
  
gerran September 14, 2018 At 1:23 pm

Hi Sir,

Can you also share the link to me? I will be using it in my office for the invoicing.

Thank you so much for the help

- Prashanth September 14, 2018 At 1:55 pm
  
  Hi,
  
  I have included the link within the tutorial itself. Please check again.
  
Cassandra September 11, 2018 At 8:56 pm

Can I have a copy of the GoogleSheet so that I can use it with my students? I have a couple kiddos who need extra supports to access the same curriculum as their peers. This would be perfect to teach them to use.

- Prashanth September 12, 2018 At 10:54 am
  
  Happy to share the number to word converter file with you. Please check your email. Also, I have updated my post and included the link.
  
SHANJU ACHARYA August 23, 2018 At 8:03 pm

PLS NEED IN INR , GIVE ME THE ACCESS

- Prashanth August 23, 2018 At 10:04 pm
  
  I have sent the Sheets via email.
  
  Regarding the converter in INR, I am Sorry to say right now I don’t have that formula.
  
  I know I can tweak the formulas used and even make it shorter. Because this converter is coded by me several months back. Now I am more accustomed to array formulas.
  
  Due to time constraint, I am unable to do that. If I make any changes, I will update that in this post in future.
  
  Thanks
  
Cristina Lim August 18, 2018 At 8:48 am

Hi Good day

Please send me the code for converting number to words.

Thanks

Charaf August 2, 2018 At 4:29 pm

Interested on the code! Thanks!

- Prashanth August 3, 2018 At 9:13 am
  
  Please Check your inbox.
  
MAlika June 11, 2018 At 3:18 pm

Please provide access

ARJUN AGARWAL April 12, 2018 At 2:25 pm

Hi Prashanth,

Could you please provide me the access.
Interested to see the code.

Thanks.

ManMohan Sharma April 12, 2018 At 12:49 pm

hi
kindly send for an access. thank

Bakhita Llames April 12, 2018 At 7:10 am

Hi! I requested for an access. Thanks!

- Prashanth April 12, 2018 At 10:01 am
  
  Done!
  
Dmitry April 5, 2018 At 2:07 am

Please give me access as well. Thank you!

- Prashanth April 5, 2018 At 5:46 am
  
  Hi Dmitry,
  
  I’ll send you the number to word converter file via Email soon. It’ll be an editable version which you can use.
  
  I’ve also noted few other requests and sending them too.
  
  Thanks.
  
Rajesh Jain April 3, 2018 At 6:00 pm

I too want in international and INR please

Oliver April 2, 2018 At 10:37 pm

Would love to see if this code works for me.

Prashanth March 30, 2018 At 12:48 pm

@john Smith, @ Babu R, @ Rajesh
Already shared via Email
Thanks for showing interest.

RAJESH March 30, 2018 At 11:16 am

Hii
Kindly share your code

Thanks

Babu R March 14, 2018 At 4:09 pm

Can I please get the command bro….

John Smith March 14, 2018 At 10:34 am

Kindly share the code/access for the code. Thanks.

Ronald Hurtado March 8, 2018 At 2:19 am

Dear Prashanth
Thanks for your time
Could you please provide the code

Again, thank you.

- Prashanth March 8, 2018 At 7:15 am
  
  Hi Ronald,
  I have already sent it to your provided mail and hope that this number to word converter can useful to you.
  
Pankaj Mishra March 7, 2018 At 10:45 am

Dear Prashanth,
I need this code of my personal use.
Thank you.

- Prashanth March 7, 2018 At 1:23 pm
  
  Done!
  
James March 3, 2018 At 5:14 am

Hello,

May I have access to the code? Thank you.

- Prashanth March 4, 2018 At 4:55 pm
  
  Hi, I’ve sent the files via email.
  
Chester March 2, 2018 At 2:48 pm

I want access

- Prashanth March 2, 2018 At 3:58 pm
  
  — Shared via email —
  
Amit February 26, 2018 At 11:55 am

i need function for INR.

apb February 17, 2018 At 9:18 pm

i need function for Indian rs

- Prashanth February 17, 2018 At 10:04 pm
  
  @apb
  I think I should tweak the formula little bit. If I make any changes, I’ll update you.
  Thanks.
  
Kashan Hanif February 16, 2018 At 1:27 pm

Hey Prashanth,

Please provide me access to this file.

Thanks

- Prashanth February 16, 2018 At 2:29 pm
  
  Done 🙂
  
Vickky February 15, 2018 At 5:53 pm

Hi,
Can you please provide access!

Thanks.

- Prashanth February 15, 2018 At 6:47 pm
  
  Hi Vickky,
  You can check your inbox. I’ve sent two spreadsheet files. Both are required.
  Thanks for the drop by!
  
Luis February 10, 2018 At 2:56 am

Interested on the code! Thanks!

- Prashanth February 10, 2018 At 7:00 am
  
  Hi,
  I’ve sent the files via personal mail.
  Thanks for the drop by.
  Cheers!
  
Joel Tan January 17, 2018 At 8:10 am

Hi, can I please get access to the code? Thank man!