Convert a numeric value into words using Excel Formula

Rahim Ali asked if a numeric value can be converted into words using formulas (not VBA). It was a mind-boggling challenge.  After a few hours of head scratching, I cracked the puzzle.



The following formula can convert amount one less than 1 trillion into words.

Download link : Convert values into words

Style 1 : Truncation to the next nearest integer towards 0

For example : $ 1,250.50  =   One Thousand Two Hundred Fifty Dollars

$1,250.50 is placed in cell B3.

Paste the following formula in cell C3.

Style 2 : Including two decimal places

Note : It works for a value having two decimal places. It truncates if you have a value having more than two decimal places.

For example :  $ 1,250.50  =  One Thousand Two Hundred Fifty Dollars and Fifty Cents

$1,250.50 is placed in cell B5.

Paste the following formula in cell C5.
Download link : Convert values into words
Spread the Word!
Share
Related Posts
About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 10 years of experience in data science. During his tenure, he has worked with global clients in various domains like Banking, Insurance, Private Equity, Telecom and Human Resource.

13 Responses to "Convert a numeric value into words using Excel Formula"
  1. want to use rupees instead of dollars

    ReplyDelete
  2. Replace "dollars" with "rupees" by pressing CTRL H shortcut key. Similarly, you can replace "cents" with "paisa".

    ReplyDelete
  3. how can add " ONLY " AFTER THE AMOUNT....?

    ReplyDelete
  4. how can i replace the decimals with fraction?
    like "One Thousand Two Hundred Fifty Dollars and 50/100 cents"

    ReplyDelete
  5. Hi
    Can you provide this formula for entering amount in crores, lakhs(Indian format).
    It will be of great help.
    Thanks in advance
    Regards
    Prateek

    ReplyDelete
  6. youuuuuuuuuuuuuu are awesome! thank you!

    ReplyDelete
  7. Dear Deepanshu,
    It would be of great help if your formula be applicable for Indian format (Ex - 0ne Crore Thirty Seven Lakhs Seventy Three Thousand Eight Hundred And twenty Five Rupees Only)

    ReplyDelete
    Replies
    1. after the formula add this

      & " only"

      the Rupees can be replaced by Ctrl H or change manually at the last formula you'll notice dollar and dollars.

      Delete
  8. Please Update This Formula with the base of Indian currency rupees mode

    ReplyDelete
  9. Is it possible to change this $0.00 -> "dollars and cents" into a 0.00% -> "percent"? Thanks in advance, this is amazing!

    ReplyDelete
  10. how do I make it should be 100 = one hundred without the word Dollars ?

    ReplyDelete

Next → ← Prev

Looks like you are using an ad blocker!

To continue reading you need to turnoff adblocker and refresh the page. We rely on advertising to help fund our site. Please whitelist us if you enjoy our content.