Digits to text

[Manju]

Hello Everyone,
This is my first time.
Maybe some one has opened this topic already.
How do I automatically convert digits to text for example 1234 as "One
thousand two hundred thirty four". There is a command available as
Bahttext() for the same but it converts the same in Thai text.
Can anyone help me?
Thanks

 

[Paul B]

Manju, have a look here,

http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Marcelo]

try it

http://www.j-walk.com/ss/excel/usertips/tip002.htm
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Manju" escreveu: