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"