# 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.

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.

#### Excel Tutorials : 100 Excel Tutorials

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 7 years of experience in data science and predictive modeling. During his tenure, he has worked with global clients in various domains like banking, Telecom, HR and Health Insurance.

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

Let's Get Connected: Email | LinkedIn