Skip to main content

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

Kutools for Excel

Boosts Excel With 300+
Powerful Features

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: Over 300 handy tools at your fingertips! Start your 30-day free trial with no feature limitations today. Download 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 30 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
sir, please teach me how replace dollar to peso, in converting numbers to words in currency/
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
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
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
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
how to to convert numbers in value. please help
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
your VBA code for Spellnumber gives a syntax error
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
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....
There are no comments posted here yet
Load More
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations