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

Excel Tutorials : 100 Excel Tutorials
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 and predictive modeling. During his tenure, he has worked with global clients in various domains like Banking, Insurance, Telecom and Human Resource.

While I love having friends who agree, I only learn from those who don't.

Let's Get Connected: Email | LinkedIn

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

Next → ← Prev