Note : It works for a value having two decimal places. It truncates if you have a value having more than two decimal places.
Note : The following formula can convert amount one less than 1 trillion into words.
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.
source : http://www.listendata.com/2013/12/co...rds-using.html
Please Login or Register to view this content.