how to express number "9" to "Nine"
 

I want to express a number in to text format

2235 to "Two thousand two hundred thirtyfive"

how to express number "9" to "Nine"
 

Hi,

There are lots of exaples of code to do this on the net which you could
Google. This is as good as any

http://www.ozgrid.com/VBA/ValueToWords.htm

Mike

"Zahir Alam" wrote:

I want to express a number in to text format

2235 to "Two thousand two hundred thirtyfive"

how to express number "9" to "Nine"
 

There are several ways to do it. This is my favorite:
http://www.xldynamic.com/source/xld.xlFAQ0004.html


Regards,
Ryan---

--
RyGuy


"Mike H" wrote:

Hi,

There are lots of exaples of code to do this on the net which you could
Google. This is as good as any

http://www.ozgrid.com/VBA/ValueToWords.htm

Mike

"Zahir Alam" wrote:

I want to express a number in to text format

2235 to "Two thousand two hundred thirtyfive"