HOW DO I CONVERT A NUMERIC IN WORDS? EG. 100 (ONE HUNDRED)
I want to convert a numeric cell into words.
Eg. Cell A1 = 400,000 Convert the Cell A1 into words in Cell A2. The result shall be 'Four hundred thousand'. |
HOW DO I CONVERT A NUMERIC IN WORDS? EG. 100 (ONE HUNDRED)
Take a look at this link:
http://www.xldynamic.com/source/xld.xlFAQ0004.html for a few solutions. Hope this helps. Pete On Dec 22, 6:46*am, Manny wrote: I want to convert a numeric cell into words. Eg. *Cell A1 *= *400,000 Convert the Cell A1 into words in Cell A2. The result shall be 'Four hundred thousand'. |
All times are GMT +1. The time now is 12:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com