Problem in Conversion

U

usm

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. :)
 
P

Peo Sjoblom

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
 
Top