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
Love this Post? Spread the Word!
Comment and share to motivate us to write more!
About Author:

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

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*
Related Posts:
9 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

We have Zero Tolerance to Spam. Comments with links will be deleted immediately upon our review.

Next → ← Prev
Scroll to Top