ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   convert numeric value to words, error msg! (https://www.excelbanter.com/excel-discussion-misc-queries/83031-convert-numeric-value-words-error-msg.html)

HHTrang

convert numeric value to words, error msg!
 
Hi, I have followed the instruction to convert anumeric value to English
words. Typr =spellnumber(32.50) but it informed an error msg "name?". I do
not know what to do. I also downloaded the FUNCUSTOMIZE.DLL zipfile but do
not know how to install it. There is not clear instruction. How can I do now?
And can I change the currency name? Thank you.

Peo Sjobom

convert numeric value to words, error msg!
 
Did you put the code in a module?

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Nothwest 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


"HHTrang" wrote in message
...
Hi, I have followed the instruction to convert anumeric value to English
words. Typr =spellnumber(32.50) but it informed an error msg "name?". I do
not know what to do. I also downloaded the FUNCUSTOMIZE.DLL zipfile but do
not know how to install it. There is not clear instruction. How can I do
now?
And can I change the currency name? Thank you.




Bob Phillips

convert numeric value to words, error msg!
 
You need to install a UDF named SpellNumber, which should be available
wherever you got the instructions from.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"HHTrang" wrote in message
...
Hi, I have followed the instruction to convert anumeric value to English
words. Typr =spellnumber(32.50) but it informed an error msg "name?". I do
not know what to do. I also downloaded the FUNCUSTOMIZE.DLL zipfile but do
not know how to install it. There is not clear instruction. How can I do

now?
And can I change the currency name? Thank you.





All times are GMT +1. The time now is 11:48 AM.

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