ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to Spell Number in English? I mean write 1 & see One? (https://www.excelbanter.com/excel-worksheet-functions/224679-how-spell-number-english-i-mean-write-1-see-one.html)

KVS

How to Spell Number in English? I mean write 1 & see One?
 
I want to enter the number in one cell & see the English number in words in
the other formulated cell. What is the Forulla? how to write it?

Jacob Skaria

How to Spell Number in English? I mean write 1 & see One?
 
Please refer http://www.ozgrid.com/VBA/CurrencyToWords.htm

If this post helps click Yes
---------------
Jacob Skaria

"KVS" wrote:

I want to enter the number in one cell & see the English number in words in
the other formulated cell. What is the Forulla? how to write it?


Ashish Mathur[_2_]

How to Spell Number in English? I mean write 1 & see One?
 
Hi,

You can also download the xlmore func addin and then use the NBTEXT()
function.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"KVS" wrote in message
...
I want to enter the number in one cell & see the English number in words
in
the other formulated cell. What is the Forulla? how to write it?




All times are GMT +1. The time now is 07:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com