ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HOW DO I CONVERT A NUMERIC IN WORDS? EG. 100 (ONE HUNDRED) (https://www.excelbanter.com/excel-discussion-misc-queries/214395-how-do-i-convert-numeric-words-eg-100-one-hundred.html)

Manny

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


Pete_UK

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