ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problem in Conversion (https://www.excelbanter.com/excel-discussion-misc-queries/94545-problem-conversion.html)

usm

Problem in Conversion
 

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


Peo Sjoblom

Problem in Conversion
 
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





All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com