Convert a numeric value into words using Excel Formula

Best Online Course : SAS Programming with 50+ Case Studies

- Explain Programming Concepts in Simple English
- Live Projects & Case Studies
- Job Placement Assistance
- Get 10% off till Sep 11, 2017
- Batch starts from October 8, 2017

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 close to 7 years of experience in data science and predictive modeling. During his tenure, he has worked with global clients in various domains like retail and commercial banking, Telecom, HR and Automotive.


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:

3 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

Next → ← Prev