HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE
 

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

HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE
 

???????????

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bkr" wrote in message
...
HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE in excel any verson

HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE
 

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
"bkr" wrote in message
...
HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE in excel any verson

HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE
 

Niek

Maybe numbers to words?

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


Gord Dibben MS Excel MVP

On Sat, 29 Aug 2009 17:56:01 +0200, "Niek Otten" wrote:

???????????

HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE
 

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"bkr" wrote:

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

HOW TO WRITE INWORD FORMAT OF A NUMERIC VALUE
 

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...b;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