HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE

[bkr]

HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE in excel any verson

 

[Niek Otten]

???????????

 

[JP Ronse]

Hi,

Please, do not use capitals for posting your question.

If you mean: how to enter a value as text, use ' e.g. '4
Wkr,

JP

 

[Gord Dibben]

Niek

Maybe numbers to words?

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


Gord Dibben MS Excel MVP

 

[Shane Devenshire]

Hi,

You can get free code to convert numerical entries to text, such as 123 to
One Hundred Twenty Three, at the following web site:

http://support.microsoft.com/kb/213360

 

[Bernd P]

Hello,

http://www.xldynamic.com/source/xld.xlFAQ0004.html
(the VBA code) returns for
1000000000000000 "One Dollar Only"
0.123 "Dollars And 12"

Microsofts site http://support.microsoft.com/default.aspx?scid=kb;en-us;213360
returns for
1000000000000000 "Hundred Fifteen Dollars and No Cents"
-20.123 "Hundred Twenty Dollars and Twelve Cents"

In my humble opinion you should NOT use these programs because they do
not apply a proper parameter check.

I suggest to use http://www.sulprobil.com/html/spellnumber.html
instead or to use Rick's code. His one seems to work fine as well.

Regards,
Bernd