Note: The other languages of the website are Google-translated. Back to English

Quickly convert or spell out a number into English words in Excel

In Excel, you may need to convert or spell out a numeric value (a number) into English words, such as to convert 100.25 into English words “One hundred dollars and twenty-five cents”. There is no effective function except using a VBA code to solve it in Excel. But with Kutools for Excel’s Numbers to Words feature, you convert the numbers into English, Chinese words or English, Chinese currency words quickly and easily.

Convert numbers to English or Chinese words currency

Convert number to English or Chinese words only


Convert numbers to English or Chinese words currency

1. Highlight the range that you want to spell out numbers into English or Chinese currency spellings, and then click Kutools > Content > Numbers to Words, see screenshot:

2. In the Numbers to Currency Words dialog box, specify the languages in the dialog box you need. And there is a built-in Preview pane for you to see the results instantly. See screenshot:

3. Then click OK or Apply. All of the numbers have been converted into English currency Words. See screenshots:

Note: If you don't want to show the commas in the currency results, please check No commas in the Numbers to Currency Words dialog box.


Convert number to English or Chinese words only

Sometimes, you just want to convert the numbers to English or Chinese words only, such as, convert 1234 to One thousand two hundred thirty-four, please do as this:

1. Please apply the feature by clicking Kutools > Content > Numbers to Words, and then, in the Numbers to Currency Words dialog box:

  • Specify the languages that you want to convert into;
  • Then, check Not converted to Currency from the Options.

2. Then click OK or Apply. All of the numbers have been converted into English Words only as below screenshot shown:

Note: Please check No commas in the Numbers to Currency Words dialog box if you don't want to show the commas in the English words.


Demo: Spell out numbers to English or Chinese Words


Kutools for Excel includes more than 300 handy tools for Excel, free to try without limitation in 30 days. Download and Free Trial Now!

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Comments (16)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
need to change the numeric number to text eg. 32.5 to in another cell in text format thirty doller two fifty cent
This comment was minimized by the moderator on the site
number change to word formula in Excel
This comment was minimized by the moderator on the site
how to convert word to number in excel 2007 and 2010
This comment was minimized by the moderator on the site
CONTACT ME 9993404554
This comment was minimized by the moderator on the site
Is there any way to convert number in INR in excel 2007 without using macros or vba. as by using same i am not able to merge the same with MS Word for preparing letters. Any help would be appreciable.
This comment was minimized by the moderator on the site
Sir i need this format VBA for Rial omani currency. 15.562 Fifteen Rials & five hundred sixty two Baisas only pls help me on this....
This comment was minimized by the moderator on the site
Sir I need excel formula for convert Pak Rupees numbers into Word. Regards
This comment was minimized by the moderator on the site
your VBA code for Spellnumber gives a syntax error
This comment was minimized by the moderator on the site
how to convert numeric value into words
This comment was minimized by the moderator on the site
how to to convert numbers in value. please help
This comment was minimized by the moderator on the site
I need to convert PKR and USD in numbers into word, please help in excel or ad-on
This comment was minimized by the moderator on the site
Hey, I am from India and need to Spell Out Numbers in words in Indian Rupee Format. Please help as it shows only in dollars . Make it convenient for individual currencies.
This comment was minimized by the moderator on the site
Please make the following corrections to the webpage (read: website) and the Kutools Add-in: numbers twenty-one (21) through ninety-nine (99) are hyphenated when spelled.
This comment was minimized by the moderator on the site
Hello,

Do you mean the 21 should be spelled as twenty-one and 99 should be spelled as ninety-nine? :)

Thanks in advance.
This comment was minimized by the moderator on the site
Cześć! W ostatnich latach, jest on niewątpliwie wpływa wejście informacyjnych. Według tego tematu, działa przedsiębiorstwo jest drażliwy temat, który ma znaczną władzę na impuls firmy. Polecam do zbadania dalszych okoliczności, zanim zaczęła się zmieniać głównego systemu. Poszukaj korzystania z cyfryzacji służbowe, na przykład elektroniczny pokojowej danych online dokumentalnym, w chmurze lub komunikacji korporacyjnej w Internecie. Wystarczy poszukać nowych możliwości. I awansować określić z VDR miękkich np virtual deal room.
This comment was minimized by the moderator on the site
sir, please teach me how replace dollar to peso, in converting numbers to words in currency/
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations