If you download and install Morefunc by Laurent Longre

http://xcell05.free.fr/english/

among other great functions there is one called NBTEXT in where you can set
if you want spelled numbers, spelled currency etc

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"usm" wrote in message
...

Hello,
I have posted a thread about "* How to convert digits into
characters"*, and got the answer, but the only problem I am facing is
that I want result *with out any currency label/description*. 2ndly, I
am unable to take the results again as I* re-open the excel program*. I
have to *re-enter the whole procedure for THAT RESULT.*

Looking for kind & valuable assistance. :)


--
usm
------------------------------------------------------------------------
usm's Profile:
http://www.excelforum.com/member.php...o&userid=34697
View this thread: http://www.excelforum.com/showthread...hreadid=552908